| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Excel files within multiple levels of a directory
Let's say I have a directory structure like this:
FOLDER1 FOLDER 1A FOLDER 1A1 FOLDER 1A2 FOLDER 1B FOLDER 1B1 FOLDER 1B2 I want to be able to select a high level folder and then open all XLS workbooks that are in every folder below it. I'm not even sure how to begin with this. Also, I think I've seen somewhere that there's a way to allow the user to CANCEL during execution of a macro. How do I do that? Thanks in advance, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing local workstation's TEMP directory | Excel Programming | |||
| Ascertaining the directory name (2 levels up) | Excel Programming | |||
| How do I get Multiple subtotal levels in EXCEL? | Excel Discussion (Misc queries) | |||
| accessing a workbook cell in a different directory | Excel Programming | |||
| Check if directory empty OR no of files in directory. | Excel Programming | |||
Threaded Mode
