| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Files Using a Macro
Hello,
I would like to open a series of files one at a time, print them and then close before opening the next. The files will be named in order, for example AAA1.xls, AAA2.xls, AAA3xls, etc. and will be in the same directories. Please could someone help me out in terms of writing the macro so it will open each file in turn (there are too many files to open in one go). Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
| Opening files | Excel Discussion (Misc queries) | |||
| Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
| Macro for opening files that changes names | Excel Discussion (Misc queries) | |||
| How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
![Mark Costello[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
