>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', 6)
>
>what am i missing?
The second parameter for the SaveAs method. The format constant for CSV is 6, DBF3 is 8.
Mark McCasland
Midlothian, TX USA