>>
>>
>>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 :-)
Nice - thanks!
>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.
Hmm, not sure if that properly simulates the case where Excel couldn't be properly instantiated in the CREATEOBJECT( ) call.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up