>>>>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")
>
>Upon further investigation, oExcel = GETOBJECT(, "Excel.Application") does work if Excel is already running.
>
>If an instance of Excel is not yet running then I get the OLE error code. I can trap the error and do a CREATEOBJECT() if the error occurs but why should I need to do this when GETOBJECT() is supposed to create an instance if one is not yet running?
>
>Any ideas why GETOBJECT() is not creating an instance of Excel? (I am using VFP5.0a)
>
>thanks,
>
>Alain
Alain,
If you call getobject("","Excel.Application") it works though an Excel is not active. But OTOH it doesn't mean that it would invoke an existing Excel session if the other session is not started from within VFP. You could check it with WINAPI - isrun32.zip in files\classes section - but I don't know then how would you have a ref to it VFP :(
Cetin