VBE file open coding
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.
|