Change color of hyperlinks in multiple documents
I added that with options code and I didn't see any difference. The hyperlink style was not applied to the links in the test documents. I have attached 2 of those 3 test files along with the latest macro ("Update Document Link Color").
There are other issues with this macro:
1. Sometimes it opens only the files in the selected folder, but mostly it opens those AND other files, possible some on One Drive. But since I select one folder (on my regular desktop), I expect it to look only there.
2. Various attempts to set the font color in the hyperlink style of each document opened by the macro have failed.
3. The macro does not apply the hyperlink style to the links in the document opened by the macro.
I have had success ON OCCASION with numbers 1-3 above, but each time I ran the macro again, it did not do what it is supposed to do. I don't know what else to do with this thing. I've spent hours and hours trying different things (and I am not a VBA developer) and coming up empty. Perhaps you can look at the code and give me some advice. It seems that, since Word is driven by style, it should be fairly easy to create a macro that opens Word documents, sets their hyperlink styles (followed hyperlinks as well), and applies those styles to the links in those documents, saves them and closes them.
|