I am running MSOffice2000, in particular Excel2K and Outlook2K. I am using VBA code from within Outlook to create an Excel object, open a workbook, suck out some data, close the workbook, quit the Excel object, etc. The code works fine from Word, MSProject, PowerPoint, etc., but does not work from Outlook. In particular, the Excel object seems to linger in the background after the instance has been "quit". Relevant code:
[vba]
Dim xlAppl As Object
Set xlAppl = CreateObject("Excel.Application")
... relevant operations ...
xlAppl.Quit
[/vba] So either I am doing something wrong or Outlook is not behaving itself. If the former, why does the approach work for other MS appls. If the latter, is this a common problem?