Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IMPLEMENTing Excel 2003
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
IMPLEMENTing Excel 2003
Miscellaneous
Thread ID:
00882133
Message ID:
00882133
Views:
54
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 &&OLEPUBLIC

	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
Next
Reply
Map
View

Click here to load this message in the networking platform