Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to save the Excel file as DBF format
Message
From
25/01/2011 04:23:40
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
25/01/2011 03:34:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01497313
Message ID:
01497324
Views:
60
Hi,
I use SAVE AS to change the excel file into DBF file,
but it have error at SaveAs statement.

What's wrong ?
vfile= "W110120.XLS"
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(vFile)
tSheets = oWorkbook.Sheets.Count             && get total of sheets
oExcel.Workbooks.SaveAs("W110120.DBF",8)
Please advise.
Thanks.
Derek
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform