title: Vba Excel do vlookup from a closed file
body: <p>I would like to do a vlookup from a close file to an active open file, The path of the closed file will be given as a variant </p>
  
  <p>Lets say       <code>mypath = "C:\list\...."</code></p>
  
  <p>I don't know if it is better to set the path only or the full-path (path+filename)</p>
  
  <p>Could u please help ?</p>