>>>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