Open a File "Quietly"

  • Thread starter Thread starter cogent
  • Start date Start date
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
 
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
 
strTitle = ActiveWindow.Caption ' To save current caption.
ActiveWindow.Caption = ""
'Your file processing code.
ActiveWindow.Caption = strTitle

HTH
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening a .csv file thru a macro 3
Macro files will not open 1
Opening .CSV file 3
Save Excel file to a CSV without opening it first 4
Open CSV File 4
Open CSV File 3
Word After a re-boot all Word files were changed to Picture files 4
macros opening files 4

Back
Top