autocad Hyper links

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
 
D

Don Guillett

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

mohamad attar

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top