| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing File Names and Linking Cells between workbooks
Hello,
I have one master Workbook where I am bringing worksheets in from other Workbooks. Some of the cells are linked with Name, Date, and Project Number which resides in the master workbook and must transfer when the worksheet is brought in.. My Problem is: My master workbook can change names which affects the linked data file name in the worksheets I am bringing in. The code in the linked cell reads ='Z:\Project Forms XLS\[My Project Template.xls]Menu'!$E$5 but my file name can change. Can I use a variable or something in my linked data to accommodate changing master worksheet file names? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Cells accross Workbooks using Column Names | Excel Discussion (Misc queries) | |||
| Are relative file locations possible in linking workbooks? | Excel Discussion (Misc queries) | |||
| Linking Workbooks using file names in a range | Excel Worksheet Functions | |||
| Linking to Workbooks with Constantly Changing Names | Excel Discussion (Misc queries) | |||
| Linking Cells to a file that changes names | Excel Discussion (Misc queries) | |||
Threaded Mode
