How to suppress saveas dialog in excel

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to suppress saveas dialog in excel

Message

From

09/07/2009 17:26:57

Naomi Nosonovsky
Wisconsin, United States

09/07/2009 17:22:21

Don Freeman
Pag
Tucson, Arizona, United States

General information

Forum:

Visual FoxPro

Category:

COM/DCOM and OLE Automation

Title:

Re: How to suppress saveas dialog in excel

Miscellaneous

Thread ID:

01411278

Message ID:

01411279

Views:

This message has been marked as the solution to the initial question of the thread.

>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.

?

If it's not broken, fix it until it is.

My Blog

Map

View

Click here to load this message in the networking platform