Results 1 to 2 of 2
2012-11-13, 09:28 #1
- Join Date
- Nov 2012
- Thanked 0 Times in 0 Posts
VBA/macros - check all internal links
I have documents that range from 25 pages to over 500 pages. In these docs, there are references (Table 1, Figure 1, see Appendix 2, etc). Instead of manually checking these links (see Table 1, go to Appendix 1), I'd like to learn how to create a macro that would check and confirm the link is going to the correct location. These docs are not written by me and sometimes have 2-4 different contributors.
2012-11-13, 16:06 #2
- Join Date
- Jan 2001
- Melbourne, Victoria, Australia
- Thanked 195 Times in 182 Posts
What is the algorithm for identifying what the target should be?
If the references are live Cross-References then the only problem you could identify by a macro is when the result shows either "0" or "Error Reference not found". If the cross-reference is actually pointing to the wrong place then it will require a human to read the paragraph and work this out unless you have a very robust way of allowing the macro to determine when a reference is wrong.Andrew Lockton, Chrysalis Design, Melbourne Australia