Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing external excel files
I have an excel sheet calculating cost for various parts. There are
many versions of this sheet (different one for each part number). I want all of these sheets to pull some common parameters from one master sheet. This way when these parameters need changed, it must only be done one time. Then all other sheets can be updated. The problem I'm having is that all these excel files while all in the same common folder, are also divided up in subfolders. Is there generic method I can use so they will find the file to import from regardless of whether the master file is in the same folder, a folder above, or even two folders above? (i.e. I only want to have one copy of the master sheet with variable parameters, and not have to make a copy of it inside each individual folder also.) Any help or suggestions will be very appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing external excel files
If you are talking a linking formula, and you want to link to a closed
workbook, then I think you would need to know where the file is located if it isn't in the same subdirectory. -- Regards, Tom Ogilvy " wrote: I have an excel sheet calculating cost for various parts. There are many versions of this sheet (different one for each part number). I want all of these sheets to pull some common parameters from one master sheet. This way when these parameters need changed, it must only be done one time. Then all other sheets can be updated. The problem I'm having is that all these excel files while all in the same common folder, are also divided up in subfolders. Is there generic method I can use so they will find the file to import from regardless of whether the master file is in the same folder, a folder above, or even two folders above? (i.e. I only want to have one copy of the master sheet with variable parameters, and not have to make a copy of it inside each individual folder also.) Any help or suggestions will be very appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing Excel files within multiple levels of a directory | Excel Programming | |||
accessing worksheets from 2 excel files | Excel Programming | |||
Trouble accessing a couple of established Excel 97 files | Excel Discussion (Misc queries) | |||
Accessing external test equipment using Excel | Excel Programming | |||
Accessing PowerPoint files from Excel | Excel Programming |