autocad Hyper links

  • Thread starter Thread starter mohamad attar
  • Start date Start date
M

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
 
Instead I would suggest just typing in the link and then using a
double_click event to FOLLOW HYPERLINK.
 
thanks for help but can u explain more how i can use the double click
event
Click to expand...
==========
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
 
Back
Top