Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to code Save As to Excel file in VFP
Message
From
08/12/2011 05:10:53
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to code Save As to Excel file in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01530603
Message ID:
01530603
Views:
166
Hi,
I want to save a file as Xls format using the parameter xlWork bookNormal

How to use it in oWorkbook.SaveAs() ?
# DEFINE xlWorkbookNormal   -  4143

oExcel = CREATEOBJECT([Excel.Application])
oWorkbook = oExcel.Workbooks.open(cxlsfile)
oExcel.Visible = .t.
oWorkbook.SaveAs('c:\FirstTest.XLS')
Next
Reply
Map
View

Click here to load this message in the networking platform