Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to save the Excel file as DBF format
Message
De
25/01/2011 04:23:40
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
À
25/01/2011 03:34:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01497313
Message ID:
01497324
Vues:
61
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform