I usually do something like this:
WAIT WINDOW [Finding Excel...] NOWAIT NOCLEAR
LOCAL loExcel AS Excel.Application, loWorkbook AS Excel.Workbook,
loSheet AS EXCEL.Worksheet
TRY
loExcel=GETOBJECT(,[excel.application])
CATCH && swallow the error if excel isn't running.
ENDTRY
IF VARTYPE(loExcel)<>[O]
TRY
loExcel=NEWOBJECT([excel.application])
CATCH TO loError
FINALLY
ENDTRY
ENDIF
Rafael Copquin wrote:
> I usually use this code to launch Excel via automation:
>
> if upper(vartype(thisform.oExcel)) <> "O"
> thisform.oExcel=createobject("Excel.Application")
> else
> thisform.oExcel=getobject( , "Excel.Application")
> endif
>
> The above code was derived from the Hacker's Guide by Tamar Granor and
> others.
>
> However, if I wanted to know in advance whether an instance of Excel is open
> in the user's computer, is there any API call or function that would tell me
> this]
>
> And if there is, could any of you post the code to accomplish this]
>
> TIA
>
> Rafael Copquin
>
--
Richard Kaye
Vice President
Artfact/RFC Systems
Voice: 617.219.1038
Fax: 617.219.1001
For the fastest response time, please send your support
queries to:
Technical Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]
---------------------------------------------------------
This message has been checked for viruses before sending.
---------------------------------------------------------
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
