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