Open a File "Quietly"

C

cogent

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
 
E

Edwin Tam

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
 
P

pfsardella

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

HTH
Paul
 
Top