Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Starting Excel with Personal.xls
Message
 
To
20/08/2004 18:46:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00935086
Message ID:
00935101
Views:
27
>Starting Excel through Automation doen't load the XLSTART\PERSONAL.XLS macro file automatically. Running Excel from the Desktop loads Personal.xls from the XLSTART directory by default. How can I load and run PERSONAL.XLS from VFP?
>
>My code to start:
>cExcelFileName = 'c:\excel\shop\1-0960-01.xls'
>
>oExcel = CREATEOBJECT('Excel.Application')
>* I would like PERSONAL.XLS to load here.
>* Then execute PERSONAL.XLS here.
>oExcel.Workbooks.OPEN( cExcelFileName )
>oExcel.VISIBLE = .T.
>
>Thanks.
>
Bill,

You'll probably have to explicity open the file. I'm not sure, but I don't think that you can pass a parameter to the object in CREATEOBJECT(). I could be wrong, however.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform