Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
space delimited files now tab delimited | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
Dialogs SaveAs with different directory | Excel Programming | |||
Dialogs | Excel Discussion (Misc queries) |