| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
variable in link
Linking 2 workbooks to transfer data from one to the other; the path to the
source workbook will always be the same except for one of the folders, which is the project number and will vary every time. Is there an easier or more elegant way to insert this variable folder into the link path other than CONCATENATE? I have several options on how to get user to enter the project number, but am missing that final step of getting user's input into the path link. Example: '\\server\abc\def\PROJECT NUMBER GOES HERE\[filename.xls]worksheetname'!a1. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
| How to add a variable as a parameter for a link? | Excel Worksheet Functions | |||
| How to add a variable as a parameter for a link? | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Update only 1 variable in a link | Links and Linking in Excel | |||
Threaded Mode
