How to Suppress Dialog-Boxes while saveas text ??


Posted by Raja on December 20, 2000 9:20 AM

Hi All,

Refer to the following Syntax

xlTextMSDOS = 21 'MS-DOS Text format
.
.
mywkbook.sheets("sheet1").SaveAs FileName:="C:\RCK\DATA\IFILE.txt", FileFormat:=xlTextMSDOS
myexcel.Quit

In the above case the File should be saved as text and Excel should be closed.
But as there are numerous dialog-boxes before the file is saved and the Excel application is closed..
like..
1. File already exists Overwrite Y or N ??
2. Do you want to save changes to IFILE.txt Y or N ??
3. Features not compatible with Text format do U want to continue Y or N ??

Could anyone let me know of a way to supress all these dialog boxes and do a "FORCED SAVE"

Thanks,
Rgds,
Rajaram

Posted by Bruce on December 20, 2000 9:53 AM

try adding
Application.DisplayAlerts = False



Posted by raja on December 20, 2000 10:10 AM

Thanks Very Much,
It worked successfully!!!

Rgds,
Rajaram