View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default 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,