Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel: check if invocation successful
Message
 
À
12/02/2015 16:32:47
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01615261
Message ID:
01615263
Vues:
50
>
* 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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform