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

Click here to load this message in the networking platform