Hi!
I've been fighting with this problem for a few days already now, so I hope someone have a solution to it *wink wink*
Well, I've a few Excel files a directory which I need to process EACH IN TURN. This means for each file, I've to open Excel using the CreateObject function and then close the application before I can process the next file. Now the problem is that even I've used Quit to close my Excel application, if I check from NT Task Manager I can still see the procecss EXCEL.EXE running which I DO NO want! And that's a reason that (I think) is preventing me to process the next Excel file. Is there any way to kill that process? I've in this web site and I've found several way of killing process BUT none of them fit my situation whereby I don't have the process ID at all. Is there any way I can retrieve that ID during runtime?
Last thing (I can hear many *sigh* now :P). While processing my Excel worksheets, I'm using Sheets.Procedure. Is there a way to set it to nothing after use? Like Set Sheets = Nothing? Does that work? Or any alternative?
Regards,
virux
