Re: Batch checking validity of hyperlinks in Msoft files

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" <maildephil@xxxxxxxxx> wrote in message news:1153739081.841473.150650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Relative Hyperlinks
    ... I've placed many hyperlinks to *.pdf files in my slide presentation. ... in the same directory folder as my presentation. ...
    (microsoft.public.powerpoint)
  • Wild Card Search Excel 2003
    ... I am using the following function to search a folder and display all ... of its PDF files as hyperlinks using the following module. ...
    (microsoft.public.excel.programming)
  • Re: Hyperlink list in excel
    ... You could just run/create a new hyperlinked list each time each time the folder location changes. ... I have a group of engineers that have an excel sheet with a list of ... hyperlinks linked to pdf files. ...
    (microsoft.public.excel.misc)
  • Update Hyperlinks easily
    ... I have a work book that has hyperlinks to PDF files. ... the name of the folder that these PDF files are stored in has changed. ...
    (microsoft.public.excel)
  • Re: C-Drive stem folders with duplicate website info???
    ... I created a sub-folder in my new main folder (HOA WEBSITE) for my .pub file, ... "downloads" on my C-Drive stem is causing the problem?? ... Rename you PDF files to match your links and place them in the DOWNLOADS ...
    (microsoft.public.publisher.webdesign)