View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default 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