T
tkt_tang
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.
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.