If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
Display Modes | |
|
|