| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you assign a Workbook Location Path to a cell?
Example, 1st workbook pulls information from a 2nd workbook. So when that 2nd
workbook is moved to another drive or folder, the 1st workbook that addresses the 2nd workbook with the path location within the functions does not change. Is it possible to assign a cell within the 1st workbook to link the location path, file name, & tab to the 2nd workbook? What would be the function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts not printing in the location I assign on worksheet | Excel Discussion (Misc queries) | |||
| Excel 2007 - File Path location | Excel Discussion (Misc queries) | |||
| define one cell location throughout workbook? | Excel Worksheet Functions | |||
| Link a cell to another workbook with a different path | Excel Worksheet Functions | |||
| print file path and location in a footer | New Users to Excel | |||
![bcw_now[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
