| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Macro to Select All Files Within A Folder
OK! I just tried opening 800 blank workbooks on my not-so-high-spec
machine and got stuck at 313! If your folders and files are named sequentially or in a pattern, use a loop to cycle through them eg. ThisFolder1\MyFile1 ThisFolder1\MyFile2 ThisFolder2\MyFile1 ThisFolder2\MyFile2 etc. Else you'll literally have to say 'Open the file with name blahblahblah then dostuffwithit' for each individual file. That is as far as I know. If any clever people know code for 'open the first file in a folder, then the next' I'd be impressed to see it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
| Excel macro to open files within a folder | Excel Programming | |||
| "Folder Select" Dialogue - Opening multiple files from selected folder | Excel Programming | |||
| Help - applying macro to all files in folder | Excel Programming | |||
| Macro to Print All Files in a Folder | Excel Programming | |||
Threaded Mode
