Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel: check if invocation successful
Message
From
12/02/2015 16:49:44
 
 
To
12/02/2015 16:32:47
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01615261
Message ID:
01615263
Views:
51
>
* If you do something like
>
>m.loExcel = CREATEOBJECT( "Excel.Application" )
>
>* can you then reliably check if it was instantiated successfully with
>
>IF TYPE( "m.loExcel" ) == "O" AND NOT ISNULL( m.loExcel )
>  * Invocation successful
>
>
>Related question - Excel 2007 is installed in the dev VM. For test purposes is there an easy way ( short of uninstalling the product ) to temporarily tweak Excel so it won't instantiate successfully?

I prefer:
TYPE([m.loExcel.Name])
but this is just me :-)


About second question you can:
m.loExcel = CREATEOBJECT( "Excel.Application" )
Then just stop code and kill Excel with Task Manager or kill the Excel process with WMI.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform