View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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
|
|