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.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2012-11-13, 16:06 #2
- Join Date
- Jan 2001
- Melbourne, Victoria, Australia
- Thanked 143 Times in 136 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