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 <mohamadatt...@gmail.com> 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 <mohamadatt...@gmail.com> 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 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