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