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

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
|
|

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
|
|

Override dialogs on SaveAs (tab-delimited)
 

Hi,

Could you please forward the script which does convertion of XLS
file onto a tab delimited file or comma delimited file.

Thanks in advance
San

Jürgen Germonpré wrote:
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

Override dialogs on SaveAs (tab-delimited)
 

Hi,

Could you please give me the solution forconvertion of XLS
file onto a tab delimited file or comma delimited file.

Thanks in advance
samy.


--
Madasamy
------------------------------------------------------------------------
Madasamy's Profile: http://www.excelforum.com/member.php...o&userid=34146
View this thread: http://www.excelforum.com/showthread...hreadid=485441