Override dialogs on SaveAs (tab-delimited)
Application.DisplayAlerts = False
should do it.
--
Jim
"Jürgen Germonpré" wrote in message
...
| Dear all,
|
| I've created a script to automatically convert .xls files to tab delimited
| text files. It works fine, only i want to get rid of those dialog boxes
that
| are popping up all the time:
|
| "Do you want to save the changes you made to "filename" dialog ?
| "The selected file type does not support workbooks that contain multiple
| sheets"
| "Save Dialog box" ....
|
| Could there be some kind of switch to override this behaviour in a
'silent'
| kind of way ?
|
| Thanks
|
|
|