Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Re : Excel Hyperlink to Open an External File
01. Enter an Excel (version 2000) WorkSheet and construct a clickable hyperlink as follows :- =Hyperlink("C:\Apps\West\ Glycol Regeneration Package\1061-L-DW-402-3 SHT. 1.pdf","Click") 02. Upon activation of the given hyperlink, the .pdf drawing file opens as desired. 03. Then, construct another hyperlink (leading to an AutoCad drawing file) such as, =Hyperlink("C:\Apps\East\ Glycol Reboiler Package\1061-L-DW-402-3 SHT. 2.dwg","Click") 04. However, upon activation of the given hyperlink, the .dwg file does not open as desired (plus, the error message reads, "No Prrogram is Registered to Open this File"). 05. Ordinarily, the .dwg file can be opened by an AutoDesk viewer application called "AutoVue". 06. The requirement is, How could an AutoCad file be opened (via Autovue) by the activation of an Excel hyperlink ? Reckon that certain VBA coding may be added to facilitate the given requirement. 07. Pleas share your experience. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel hyperlink to another open Excel file - wants to reopen file | Excel Worksheet Functions | |||
Macro to insert a hyperlink to external file | Excel Discussion (Misc queries) | |||
open an external file | Excel Programming | |||
How to open an external tool directly from an Hyperlink? | Excel Programming | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |