| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activate Hyperlink in Named Range | Excel Worksheet Functions | |||
| Hyperlink in cells....how to activate it with out a mouse | Excel Discussion (Misc queries) | |||
| How do I activate the "greyed out" hyperlink function | Excel Discussion (Misc queries) | |||
| How do I de-activate hyperlink in Excel ? | New Users to Excel | |||
| adding text path via macro to activate hyperlink | Excel Programming | |||
Threaded Mode
