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