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.


On Feb 8, 7:37*am, mohamad attar wrote:
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

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

On Feb 9, 7:32*am, mohamad attar wrote:
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 tabview codeinsert 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