Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple VFP7 Excel file save problem
Message
From
06/05/2002 23:01:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Simple VFP7 Excel file save problem
Miscellaneous
Thread ID:
00653359
Message ID:
00653359
Views:
61
I'm having problems with doing a 'SaveAs' command within VFP7.0 to save a Excel file under a different name.

Basically, I am opening a preformatted blank Excel worksheet (let's say temp.xls), updating some text and data, then trying to save as a different file name.

Here is the basic concept code:
xLapp.ActiveWorkbook.SaveCopyAs(cFn)
&& where cFn is the full text path and name of the file to save as.
xLapp.Quit && close Excel

I need be able to programically respond to the overwrite prompt, should the (cFn) already exist, and also respond to the Save changes prompt(Yes.No.Cancel) from the temp.xls file which is still open. In the first case, I want to 'Overwrite' and in the second case select 'No'.

Anyone know the commands necessry to add to the .SaveAs.??? command...

Thanks Much!

Scott Rands
Next
Reply
Map
View

Click here to load this message in the networking platform