>>How can I change the code to detect if Excel is already running and, if so, simply add a new Workbook to the existing Excel application.
>>
>
>Instead of CREATEOBJ(), use GETOBJECT(), which will use an existing instance of the server if it's available, or start one if it isn't:
>
>oExcel=GETOBJECT(,'Excel.Application')
Thanks for the suggestion. I tried but got the following error message
Error number: 0
Error message: OLE error code 0x800401e3: Operation unavailable.
Line of code with error: oExcel = GETOBJECT(, "Excel.Application")
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