View Single Post
  #1   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)

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