Run Time error 1004
In Cell B4 I have the string Array_Test.xls
When I double-Click on it (B4)
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Workbooks.Open Filename:="C:\Documents and Settings\Jim May\&
Target.value"
End Sub
I obviously want the file Array_Test.xls to open;
but "no go", Can someone assist?
TIA,
|