Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to code Save As to Excel file in VFP
Message
 
 
To
08/12/2011 05:10:53
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
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:
01530608
Views:
61
# DEFINE xlWorkbookNormal   -4143
...
oWorkbook.SaveAs(lcFileName, xlWorkbookNormal )
>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')
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform