u25103
03-06-2008, 12:15 AM
Hi
this is my problem
I want to open a xls file based on two diffrent ranges B1 and B2.
Dim a As String
Dim b As String
Dim strFilename As String
a = Range("B1").Value
b = Range("B2").Value
strFilename = "H:\???????\???????" \ "a" & "b"".xls"
Workbooks.Open Filename:=strFilename
But it dosen't work. Is there anyone out there who can :help me??
Thanks
this is my problem
I want to open a xls file based on two diffrent ranges B1 and B2.
Dim a As String
Dim b As String
Dim strFilename As String
a = Range("B1").Value
b = Range("B2").Value
strFilename = "H:\???????\???????" \ "a" & "b"".xls"
Workbooks.Open Filename:=strFilename
But it dosen't work. Is there anyone out there who can :help me??
Thanks