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
|