Re: Batch checking validity of hyperlinks in Msoft files

Tech-Archive recommends: Speed Up your PC by fixing your registry

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 :

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

  • Re: Printing Saved Files
    ... I have it creating the PDF files now and when I'm ready to ... > Here is some code to create a PDF file using Visual FoxPro: ... Demo showing how to print a Fox report to a PDF ... > DECLARE INTEGER FindWindow IN WIN32API STRING, ...
    (microsoft.public.fox.vfp.reports.printing)
  • Re: save report as separate PDFs per group
    ... I have a report that needs to be saved as PDF. ... Here's the two parts I use to generate 3500 PDF files on demand. ... Sub Produce_PDFS ... 'Test folder existence ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with PDF
    ... is not any more producing a report than an application that ... produces output in CSV or TXT. ... I was merely suggesting to the OP that sending the output from his VB.net application to a pdf "printer" driver was indeed a good way of achieving what are his clearly stated aims. ... so that he can send the .pdf files to his users instead of the .xls files that he is currently sending them! ...
    (microsoft.public.dotnet.languages.vb)
  • Help with hyperlinks in pulldown list. Anyone know how?
    ... there is a list used as a pull down menu. ... list are actually hyperlinks. ... It all depends on the data in the report. ... the spreadsheet for calculating Bonus Tolerance. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: text (file) report to something newer
    ... PDF files are a pain to read. ... preference, not superior format. ... Printer object - I started rewriting my code to generate a report with the ... PDF - Whichever method I use I want to generate a PDF file from it. ...
    (microsoft.public.vb.general.discussion)