Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro and Excel
Message
From
15/06/2001 10:45:32
 
 
To
15/06/2001 10:35:46
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00519913
Message ID:
00519962
Views:
14
Jeff,
Try:
#DEFINE xlCSV   6
oworkbook.saveas('e:\jeff.csv', xlCSV)
HTH

>hi mark. thaanks for the replay. i'm trying to get the folloiwng ot happen:
>
>1. user from the filed submits a excel file to a central email account
>2. program shoudl go out and download the xls file from teh email temp directory
>3. save the xls file as a csv and then copy into a dbf
>
>when i attemp to save the xls into a dbf as it is, because of the macros and etc all i get i garbage into the table. when i save it manually to a csv format, it goes into the table w/o a problem. here's what ihave to read the file and save as csv...
>
>oWorkbook = oWkst.Workbooks.Open(m.att_file)
>oWksheet = owkst.Workbooks.ActiveSheet[1]
>oworkbook.saveas('e:\jeff.csv')
>
>what am i missing?
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform