Thanks Sergey,
That appears to get me past implementing the right source. Now there is a major problem with Excel Implements. As in, it doesn't work with 2003. Now, everytime I try it, I get "Class cannot be instantiated because Member 'WORKBOOKEVENTS_Sync' is not found." Any ideas?
jfh
>John,
>
>Try to change it to use PROGID
IMPLEMENTS WorkbookEvents IN "Excel.Application"
>
>>Hello,
>>I've got an app here that IMPLEMENTS Excel events:
>>
>>
>>DEFINE CLASS xlEvents AS session OLEPUBLIC
>>
>>IMPLEMENTS WorkbookEvents IN "c:\program files\microsoft office\office10\excel.exe"
>>
>>...
>>
>>
>>However, some users are now running office 2003, which has created a new folder for office ( ...\office11 ). How can I dynamically check for this and IMPLEMENT from the right source? Something like the following (which does NOT work):
>>
>>
>>DEFINE CLASS xlEvents AS session
>>
>> DO CASE
>> CASE DIRECTORY( "c:\program files\microsoft office\office10\" )
>> IMPLEMENTS WorkbookEvents IN "c:\program files\microsoft office\office10\excel.exe"
>> CASE DIRECTORY( "c:\program files\microsoft office\office11\" )
>> IMPLEMENTS WorkbookEvents IN "c:\program files\microsoft office\office11\excel.exe"
>> OTHERWISE
>> MESSAGEBOX( 'oops' )
>> ENDCASE
>>
>>...
>>
>>
>>thanks,
>>
>>jfh