excelguru123
New Member
- Joined
- Jun 23, 2021
- Messages
- 2
- Office Version
- 2013
- Platform
- Windows
Hey folks,
I am trying to write a code so that I can update 3 links at one go. I already have a code that pulls together all the currently used links, then in a cell I update those links to correspond to the updated files within a different folder. Now I am trying to use:
to update to the appropriate updated file but in the file name I am trying to pull in the path from a particular cell. for example I have my new path/file in cell C3 of Sheet1, how can I pulll in that particular cell information into the Name:="File Name" portion of the code above.
Thanks for the help
I am trying to write a code so that I can update 3 links at one go. I already have a code that pulls together all the currently used links, then in a cell I update those links to correspond to the updated files within a different folder. Now I am trying to use:
VBA Code:
ThisWorkbook.UpdateLink Name:="File Name", Type:=xlExcelLinks
to update to the appropriate updated file but in the file name I am trying to pull in the path from a particular cell. for example I have my new path/file in cell C3 of Sheet1, how can I pulll in that particular cell information into the Name:="File Name" portion of the code above.
Thanks for the help