RustEE2020
New Member
- Joined
- Feb 21, 2020
- Messages
- 30
- Office Version
- 2016
Hello,
I have an addon that copies template pages from itself into a user specified workbook when requested.
I have been using the code below to replace the external link portion of references with the name of the workbook where the page is copied.
However there is one page where only some of the references are converted.
I receive no errors so I am unsure as to why the code does not replace everything.
Is there a different method that I should be using?
I have an addon that copies template pages from itself into a user specified workbook when requested.
I have been using the code below to replace the external link portion of references with the name of the workbook where the page is copied.
However there is one page where only some of the references are converted.
I receive no errors so I am unsure as to why the code does not replace everything.
Is there a different method that I should be using?
VBA Code:
For Each WS In ActiveWorkbook.Worksheets
WS.Cells.Replace what:=ThisWorkbook.Name, Replacement:=ActiveWorkbook.Name
Next