Message
From
02/10/2006 12:46:04
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Excel file Save as .DBF
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158600
Message ID:
01158600
Views:
80
Hi,
After opening the excel spredsheet with "oWorkbook=Getobject('c:\my documents\sample.xls')". Then, I am trying to save the file as DBF with "oWorkbook.SaveAs('c:\mydocuments\sample.dbf',...)" but I am not successful. I am referencing the book "Microsoft Office Automation with Visual FoxPro", and it describes, I need to use the file format as an optional second parameter with command "...SaveAs...". I tried many different possible ways for the second parameter, but none had worked.
Thank you in advance.
Kay
After opening the excel spredsheet with "oWorkbook=Getobject('c:\my documents\sample.xls')". Then, I am trying to save the file as DBF with "oWorkbook.SaveAs('c:\mydocuments\sample.dbf',...)" but I am not successful. I am referencing the book "Microsoft Office Automation with Visual FoxPro", and it describes, I need to use the file format as an optional second parameter with command "...SaveAs...". I tried many different possible ways for the second parameter, but none had worked.
Thank you in advance.
Kay