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?
Thanks in Advance.
J. Turner