Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert variable into link path?
Posted this in Link section but no response yet so posting here. I need to
link many cells in 2 workbooks to transfer data from one to the other; the path to the source workbook will always be the same except for one folder, 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 | |||
variable path | Links and Linking in Excel | |||
can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
Insert cell value into a link path | Excel Programming | |||
How do I insert a variable for the file/path in aQuery Table? | Excel Programming | |||
variable path in a link | Excel Programming |