General information
Category:
COM/DCOM and OLE Automation
not tried but will, I'll have to store all the filenames somewhere for a batch print when required I guess.
noted a mention of for each loops causing issues and got a bit excited, however I dont use them at all! the only other thing is I create the excel instance with
oExcel = CreateObject("Excel.Application")
I don't suppose I'd be better with oExcel = CreateObject("Excel") and then getting reference to the application?
I was under the assumption that application.quit() would clean up it's parent anyway.
oh well thanks for all the help, off to try again...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only