autocad Hyper links

[mohamad attar]

i have a about 800 autocad files in a folder on the network where i
work , i want to make an excel sheet with hyperlinks for this files
once a time instead of doing them individually any help please

 

[Don Guillett]

Instead I would suggest just typing in the link and then using a
double_click event to FOLLOW HYPERLINK.

 

[mohamad attar]

thanks for help but can u explain more how i can use the double click
event

 

[Don Guillett]

thanks for help but can u explain more how i can use the double click
event

==========
OK suppose you have this typed in a cell(use actual names)

c:\folder\subfolder\filename.xls
and right click sheet tab>view code>insert this and DOUBLE click on
the cell to open the file

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
ActiveWorkbook.FollowHyperlink Address:=Target
End Sub