Using visual basic (macro) I am able to pull out hyperlink information for
those hyperlinks that exist on my powerpoint slides. I write this info to an
excel spreadsheet. Is there a clever way using a macro to automatically open
each hyperlink in the excel spreadsheet to verify it exists (maybe you get an
error code if it can't be open)?
It might be simpler to do it within PPT while you're extracting the data.
There are, at last count, 17.34 bazillion subtly different types of links in PPT
but for the most part, the hyperlink's .Address property points to the file the
hyperlink needs; the .Subaddress property points to the location within the
file.
If the link's to a file, then something like this should be enough:
If Len(Dir(.Address)) > 0 Then
Debug.Print "It exists"
End If
That'll error if it's an HTTP or FTP or EMAIL link though, so you'll have to
deal with trapping the errors or otherwise ignoring links that aren't to local
files.
You can still test some of these: PowerPoint can open files via HTTP or FTP, so
if they're html files, ppt files or other types PPT can open, you could do:
Presentations.Open .Address
and trap any errors, then .Close the presentation. Might take considerable time
if they're large files coming over a slow link.
--
Steve Rindsberg, PPT MVP
PPT FAQ:
www.pptfaq.com
PPTools:
www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA
www.PowerPointLive.com
================================================
