Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FoxPro and Excel
Message
De
15/06/2001 10:45:32
 
 
À
15/06/2001 10:35:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00519913
Message ID:
00519962
Vues:
15
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform