Batch checking validity of hyperlinks in Msoft files

[philmail]

Hello,

I'm searching a tool that can test all hyperlinks in a few files and
send a report afterwards (batch test and batch report).


The file types would be:
doc, dot, xlt, xls, vsd and pdf


Since one file can have some hyperlinks and there are +/- 150 files to
check from time to time... an automatic processing would be nice


NB : LinkFixerPlus Gold does the job.... but costs : $3670.80 !


Thanks in advance if you've got an idea...


Philippe
Switzerland

 

[Jonathan West]

Hi Philippe,

For .dot and doc files it would be relatively straightforward to create such
a tool. Use the following article as the basis for looking through a folder
of files,

Find & ReplaceAll on a batch of documents in the same folder
http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

Instead of the Find & replace code, you would instead have code iterates
through the Hyperlinks collection and creates a report. What tests do you
want done on the hyperlinks? Are the links to the web or local links to
another file in the same folder hierarchy?

I would guess that if you ask in the Excel and Visio newsgroups you would be
able to get equivalent code there.

PDF files are more of a problem. No MS Office program opens PDF files, and
the way hyperlinks are implemented in PDF files is quite different from most
other applications. If you have Adobe Acrobat installed (the commercial
version, not the free reader) you might be able to work through the Acrobat
object model - probably asking in the comp.text.pdf newsgroup would be your
best chance of finding out how to do this.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[philmail]

OK, Thanks a lot for that quick answer.

The links are pointing to other Msoffice files, in the same or other
sub directories. Alltogether, there are +/- 150 files. most of them are
tools without any links. A few of them are like indexes : "to do that
read document XY --link". And of course, with time, targets change
name, location, or disappear... And I'd like to check all of these
links in one shot, with report at the end ;-)

Regards from Switzerland

Philippe

Jonathan West a écrit :