Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel starter edition
Message
From
10/02/2012 03:13:04
 
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01535050
Message ID:
01535052
Views:
50
>>Today had a user who was having problems using my Excel automation.
>>
>>Turns out that she has a starter edition of Excel.
>>
>>Looks like this line doesn't run when the Excel installed is the starter edition:
>>
	oExcel = Createobject("Excel.Application")
>>
>>First time I've come across this edition.
>>
>>Is it correct that VFP cannot be used with Excel starter edition?
>>
>>Also, how would one test for this edition so I can give user a warning that Excel automation won't work?
>>
>>Cyril
>
>Not only VFP,
>No application can use Excel Automation with Excel Starter edition, just because it isn't installed.
>Try this:
>
>fl_error = .f.
>TRY
>   oExcel = Createobject("Excel.Application")
>CATCH
>   fl_error = .t.
>ENDTRY
>IF m.fl_error
>  MessageBox("No Excel Automation module installed on this computer")
>  RETURN
>ENDIF
>
Thanks, I didn't know that. I'll use your code suggestion.

Anyone know if there is a specific test to see if the version of Excel installed on a PC is the starter edition?

Cyril
Previous
Reply
Map
View

Click here to load this message in the networking platform