Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving Excel file
Message
 
To
19/06/2001 08:03:01
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00520931
Message ID:
00520943
Views:
16
>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

Once you have saved your file with SaveAs then just do a Quit instead of a Close. Try this and see if everything is OK.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Reply
Map
View

Click here to load this message in the networking platform