It may be as simple as setting the file association in Windows. "No Program
is Registered to Open this File". Go to MyComputer/Tools/Folder Options/File
Types. In the list of file extensions find .DWG and see if Auto View is the
program that opens this file type. If not, make it so.
To check for proper file association, in MyComputer search for *.DWG and
then double click on a drawing file. If it opens with Auto View, then your
OK. That is essentially what the hyperlink will do. It will first select a
file and then ask Windows to open the file with the program that is
registered to do so.

Mike F

wrote in message
ups.com...
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.