Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET SAFETY equivalent when saving workbook file
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
SET SAFETY equivalent when saving workbook file
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
00953497
Message ID:
00953497
Views:
55
I have a method where I am automating Excel to do some range sorting and manipulation. After that work is complete, I want to save the workbook before continuing (e.g. oExcel.ActiveWorkbook.Save() ).

Unfortunately, Excel wants to interactively confirm if I wish to replace the existing file. Is there a way I can just force the save to occur without any confirmation? I couldn't find anything in the object reference docs that would help.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Next
Reply
Map
View

Click here to load this message in the networking platform