View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_4_] Edwin Tam[_4_] is offline
external usenet poster
 
Posts: 23
Default 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