View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jürgen Germonpré[_2_] Jürgen Germonpré[_2_] is offline
external usenet poster
 
Posts: 2
Default Override dialogs on SaveAs (tab-delimited)

Ok.
It works.
Thanks a lot.

"Jim Rech" wrote in message
...
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
|
|