-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Updating link macro
- Thread starter moyemrick
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Assuming you do not mean hyperlinks....
http://www.mrexcel.com/board2/viewtopic.php?t=276872&highlight=links
Or
"Find links in a workbook" in the Excel help files. You do a find and replace operation (Ctrl + H)
Regards.
------
EDIT:
I should be more clear:
If your formulas look like -
=[BookOne.xls]Sheet1!$A$1
You can Find -
BookOne.xls
and Replace -
BookNewBook.xls
I guess I am thinking in terms of updating as changing.
------
If you mean updating links as refreshing the values:
The above code is from the help files and is supposed to update all link sources...I haven't tested it. I changed the reference from ActiveWorkbook (in the help files) to ThisWorkbook (in my code above).
Hope I have got this right for you! I suppose alternatively you could just open the link sources.
http://www.mrexcel.com/board2/viewtopic.php?t=276872&highlight=links
Or
"Find links in a workbook" in the Excel help files. You do a find and replace operation (Ctrl + H)
Regards.
------
EDIT:
I should be more clear:
If your formulas look like -
=[BookOne.xls]Sheet1!$A$1
You can Find -
BookOne.xls
and Replace -
BookNewBook.xls
I guess I am thinking in terms of updating as changing.
------
If you mean updating links as refreshing the values:
Code:
Sub MyUpdateLinks()
ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources
End SubThe above code is from the help files and is supposed to update all link sources...I haven't tested it. I changed the reference from ActiveWorkbook (in the help files) to ThisWorkbook (in my code above).
Hope I have got this right for you! I suppose alternatively you could just open the link sources.
Upvote
0
Similar threads
- Question
- Question
- Solved
