Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
16/07/1999 14:03:25
 
 
To
16/07/1999 13:26:55
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00242078
Message ID:
00242470
Views:
20
>Oscar,
>W/o path it seeks the file in "My documents" folder. Otherwise you should provide full path taking spaces into consideritaion. Then it works. Just try this :
use (home()+"samples\data\customer")
>lcFileName = sys(5)+curdir()+"myTest.xls"
>copy to (lcFileName) type xls
>oExcel= createobject("Excel.aplication")
>with oExcel
>  .WorkBooks.open(lcFileName)
>  .visible = .t.
>endwith
Cetin


Thanks Cetin. I just tried you code and stil can not see the sheet. However another thread jus popped up with a clue.

Saving an Excel sheet from FoxPro programmatically Thread #242438

If I go to the window/show menu, then it shows. I'm guessing that I have a setting into excel I don't know about or that I should set from whiting VFP.

I'll look for a Hide or show property.

Oscar
Previous
Reply
Map
View

Click here to load this message in the networking platform