Using VBA to Activate a Hyperlink
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
|