ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open files within specific file structure (https://www.excelbanter.com/excel-programming/343150-open-files-within-specific-file-structure.html)

GregR

Open files within specific file structure
 
I have a file structure like this:

G:\AA\100\Stores\Locations.............and as below

Locations
5530 New York
2005 New
Accounting
NSR 5530(Number from above) CapAllocation

Locations
5552 Chicago
2005 New
Accounting
NSR 5552(Number from above) CapAllocation

Locations
5560 Memphis
2005 New
Accounting
NSR 5560(Number from above) CapAllocation

Within this file structure, I want to open all the CapAllocation files
within a number range, which will vary each time. For instance open all
CapAllocation files for any stores between 5500 to 5540. The next time
it could be stores 1220 to 1235, etc.

Any help of how to get started would be appreciated. TIA

Greg



All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com