ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I embed a .lnk file in an Excel form? (https://www.excelbanter.com/excel-discussion-misc-queries/229359-how-do-i-embed-lnk-file-excel-form.html)

SIMPSBA

How do I embed a .lnk file in an Excel form?
 
I would like to embed a hyperlink in an Excel form to a file that resides in
an Outlook public folder and can't figure out how to do it. Anybody know if
this is possible?

Dennis Tucker

How do I embed a .lnk file in an Excel form?
 
Setup a click event with one of the visual controls on the form. Inside this event use the following


ActiveWorkbook.FollowHyperlink Address:="http://www.gohere.com", NewWindow:=True This address "http://www.gohere.com" needs to be the address of any document you want that is accessible.Dennis

"SIMPSBA" wrote in message ...
I would like to embed a hyperlink in an Excel form to a file that resides in
an Outlook public folder and can't figure out how to do it. Anybody know if
this is possible?



All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com