Hpe soemone can help. I can save my file with the save as function of excel via vfp automation. but when i attempt to close the file, it asks me if i want to save changes to the file. i'm converting an xls file to a csv file. here's what i have coded:
#DEFINE xlCSV 6
*oworkbook.saveas('e:\jeff.csv', xlCSV)
oWorkbook = oWkst.Workbooks.Open(m.att_file)
oWorkbook.sheets(1)
newcsvfile = oPro.getfilename()
oworkbook.saveas(newcsvfile, xlCSV) && this works fine. it's saved w/o any problems
oWorkbook.close() && this is where the problem comes in and the excel msg window comes up ans asks me if I would like to save changes to hte file that I just saved
owkst.quit()
release owkst
Thanks in Advance.
J. Turner