I am attempting to search the hyperlink address of various slides on a
powerpoint master slide based on the addresses contained in Excel collumn. I
have set up the necessary resources in Excel and made a start at my
definitions in VB

Dim PPApp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Hyperlink.Address

Now, I know how, on the Powerpoint, thanks to some excellent help on the
Powrpoint forum, to search and change the hyperlink.address object in
Powerpoint:

For Each s In ActivePresentation.Slides
For Each h In s.Hyperlinks
tip = h.ScreenTip
h.Address = Replace(h.Address, OldUrl, NewUrl)
h.ScreenTip = tip
h.ScreenTip = Replace(h.ScreenTip, OldUrl, NewUrl)
Next
Next

What I need is how to open the relevant powerpoint file, search on a value
from a collumn and return some sort of message saying that it was or was not
found. Not much to ask for :(

If anyone can give me a clue, I would greatly appreciate it.