Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to suppress saveas dialog in excel
Message
 
 
To
09/07/2009 17:33:52
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01411278
Message ID:
01411281
Views:
20
>>>This command
>>>
>>>oX.ActiveWorkbook.SaveAs("C:\Temp.txt", -4158,.f.)
>>>
>>>creates a warning dialog to overwrite "Temp.txt" if the file already exists. Is there a way to supress this dialog as if set safety were off?
>>>Thanks
>>
>>Did you try
>>
>>oX.DisplayAlerts = .F.
>>
>>?
>That works. Thanks Naomi.

No problem. I made a search here just in case afterwords and was going to give you a link to this thread # 1396469
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform