I am trying to write a vbe macro to look in cell J11 for a directory path,
then goto a file name found in cell J40.
I have this so far:

Open Filename
"C:\" & Range("j11").Value _
& "\" & Range("j39").Value & ".xls"

I am sure the bottom 2 line are ok, it is the first one that ia a problem.
Please can someone help with this nice easy one.

Hi, give this a try:
Workbooks.Open Filename:="C:\" & Range("j11").Value _
& "\" & Range("j39").Value & ".xls"

HTH--Lonnie M.

"Lonnie M." wrote:

Hi, give this a try:
Workbooks.Open Filename:="C:\" & Range("j11").Value _
& "\" & Range("j39").Value & ".xls"

HTH--Lonnie M.

Top guy - thanks buddy.