Re: How to insert variable into link path?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Lynn,

I cannot think of any other way...

PathPart1 = "\\server\abc\def\"
PathPart2 = "\[filename.xls]worksheetname!A1"
UserInput = ' whatever you use to obtain from UI

MyPath = PathPart1 & UserInput & PathPart2

There is nothing inelegant about this; that is the way it is done. I still feel like I'm missing something. Why the aversion to this way?


Lynn wrote:
Sorry for the late reply, away from email for a few days. That was the whole point of my question - is there a way to do it without having to concatenate several strings?
Still hoping for another way to do it...

"smartin" wrote:

Lynn wrote:
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!


Seems pretty straightforward... obtain the user input with a form control or input box and build up the path string via concatenation. Or am I missing something?

.

Relevant Pages

  • Re: How to insert variable into link path?
    ... point of my question - is there a way to do it without having to concatenate ... elegant way to insert this variable folder into the link path other than ... but am missing that final step of getting user's input into the path ... obtain the user input with a form ...
    (microsoft.public.excel.programming)
  • Re: How to insert variable into link path?
    ... 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. ... obtain the user input with a form control or input box and build up the path string via concatenation. ...
    (microsoft.public.excel.programming)
  • Re: Please help..
    ... I'm probably missing out on somthing here, but why would one want to ... Surely you don't want to update rows depending on user input, ...
    (comp.lang.php)
  • Re: Question from newbie
    ... > I'm still in learning Ada. ... there were something missing in ... > coding. ... > now doing a program that ask user input x characters and program will ...
    (comp.lang.ada)
  • Re: Strip Values From Cells To Create New Cell Value
    ... Rock Build house ... Concatenate it with the first letter of Use column (Build from Build ... House) and concatenate it with an user input which is constant for all ...
    (microsoft.public.excel.misc)