Thanks Zack

This is what I found, and it did the trick

ActiveWorkbook.FollowHyperlink Address:="C:\Test\test.pdf", NewWindow:=True

Cheers




"Zack Barresse" wrote:

Hi there,

Check out the FollowHyperlink method.

--
Regards,
Zack Barresse, aka firefytr
MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com"



"Matt" wrote in message
...
Hello Everyone

I am attempting to use VBA to activate a link to a PDF file
I can select the cell but am unsure as how to activate the link so the PDF
file is opened

My macro finds the correct cell which sas the formula
"=HYPERLINK("D:\$SWE Accounting - Invoices\HSBC Cards\2006 09 (Sep) 19 -
Mandarin Oriental - 25.00.PDF","Open File")"

If I click on this cell the file opens but I want the VBA to kick of this
action

Thanks for reading this far and in advance for any help you can give.

Cheers


Matt