View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel Hyperlink to Open an External File

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.