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,

Run Time error 1004
 

Not tested, but try:

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

The difference is that the end double quote is moved from after
".value" to after "May\". Your code makes "&Target.value" look like
part of the path.

Run Time error 1004
 

Thank you, thank you;
It works perfectly.
Jim

"Mark Lincoln" wrote in message
ups.com...
Not tested, but try:

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

The difference is that the end double quote is moved from after
".value" to after "May\". Your code makes "&Target.value" look like
part of the path.