Good afternoon Ninja's.
My VBA is not the best and I have been searching the internet for an example that I can make work but I haven't had any luck.
What I am trying to do is link two columns that will be of variable length together. Once combined, this will be the path to a specific file and cell. I would like to have the VBA code to combine the columns and once completed provide the resultant from the specified cell address.
I know that this shouldn't be too difficult but any assistance would be appreciated.
I have included a file as an example.
To note, I have tried indirect but it is not working. I believe that the reason is that it is a share point site.
I can type in directly ='\\sharepoint\support\facop\Run%20Test\[Sheet1.xlsx]Table'!$B$3 and it pulls the information but I can't seem to get the concatenated version to work. The same is true if I use an http:// format.
Thanks in advance.
Sean
Post Moved by Moderator.
.
My VBA is not the best and I have been searching the internet for an example that I can make work but I haven't had any luck.
What I am trying to do is link two columns that will be of variable length together. Once combined, this will be the path to a specific file and cell. I would like to have the VBA code to combine the columns and once completed provide the resultant from the specified cell address.
I know that this shouldn't be too difficult but any assistance would be appreciated.
I have included a file as an example.
To note, I have tried indirect but it is not working. I believe that the reason is that it is a share point site.
I can type in directly ='\\sharepoint\support\facop\Run%20Test\[Sheet1.xlsx]Table'!$B$3 and it pulls the information but I can't seem to get the concatenated version to work. The same is true if I use an http:// format.
Thanks in advance.
Sean
Post Moved by Moderator.
.
Attachments
Last edited by a moderator: