VB 5 & MS Excel 97 - Process not releasing
Posted on 2004-11-22
Have a question for you about a problem I am currently having and can not seem to get around.
The basic functions of the VB app is to perform file handling. There was a new section added to the application as a new file to be handled needed to be formatted and saves as an [Name].XLS file. It was previously in [Name].CSV format. There is no problem with the formatting code that I have written. This section works fine.
The problem seems to be that when the application has successfully formatted and moved one file to its new location it gives an error when it tries to process another file of the same type. (This is an automation error).
I think that this problem is coming down to the excel process not being released after the application has been quit. For some reason after the code has ran, if you go to the process list it will show an "excel.exe".
Does anyone have any ideas as to why this is not being released correctly? (Note; it is being released when the VB application is terminated.)
The code I am using to close this is as follows:
Set loSheet = Nothing
Set loExcel_Book = Nothing
Set loExcel_App = Nothing
Thanks in advance for any help. It is very much appreciated!