| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| linked PDF will not open "can not open specified file" is message | Excel Discussion (Misc queries) | |||
| Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
Hybrid Mode
