Hanging instance of Word and Excel objectts in Task Manager 1

[pankajv]

We are generating some excel and word documents through the VB code and saving them to the hard disk. But when we observed the Task Manager we found many instances of WinWord.exe and Excel.exe running. Can any body tell what are the possible reasons for this problem.

 

[Swi]

Are you closing it correctly?

MyXL.Application.Close
MyXL.Saved = True
MyXL.Application.Quit

Set MyXL = Nothing ' Release reference to the
' application and spreadsheet. Swi

 

[PraveenMenon]

When u create na object, u need to close it..

set the word object u r opening to Nothing when u finish exporting

something like this

set myWrdObj = Nothing
set myXLObj = Nothing

All the Best
Praveen Menon
pcmin@rediffmail.com