Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 246
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you set Excel 2007 to open files in a specific folder? Opening to a specific folder Excel Discussion (Misc queries) 2 August 12th 07 02:58 AM
Open file to specific tab [email protected] Excel Discussion (Misc queries) 5 June 16th 06 03:55 AM
file open via IE hyperlink causes already open files to shrink and tile Marc Setting up and Configuration of Excel 0 May 4th 05 08:13 PM
Open a specific file anomymousA Excel Programming 2 February 9th 05 07:16 PM
Open files from specific directory John Rawlins Excel Programming 1 October 16th 03 04:03 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"