Open a File "Quietly"
 

Hello

My macro opens a variety of "csv" files as data sources. This is of course
accomplished at high speed, but there is no real reason why the file name(s)
should appear in the taskbar separately or upon the Excel label on the
taskbar.

How can I get those files to be opened "quietly?" as in unseen?

Thank you.

W

Open a File "Quietly"
 

Before the statement which opens the file, add a line to show a dummy message in the statusbar. (can be blank or a space.

Sub open_quietly(
Application.StatusBar = "
Workbooks.Open "my_file.xls
Application.StatusBar = Fals
End Su


----- cogent wrote: ----

Hell

My macro opens a variety of "csv" files as data sources. This is of cours
accomplished at high speed, but there is no real reason why the file name(s
should appear in the taskbar separately or upon the Excel label on th
taskbar

How can I get those files to be opened "quietly?" as in unseen

Thank you

Open a File "Quietly"
 

strTitle = ActiveWindow.Caption ' To save current caption.
ActiveWindow.Caption = ""
'Your file processing code.
ActiveWindow.Caption = strTitle

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Hello

My macro opens a variety of "csv" files as data sources. This is of course
accomplished at high speed, but there is no real reason why the file name(s)
should appear in the taskbar separately or upon the Excel label on the
taskbar.

How can I get those files to be opened "quietly?" as in unseen?

Thank you.

W