title: VBA vlookup formula refering another opened workbook
body: <p>I am trying to add a vlookup formula by using VBA, however, it didn't work for me. It's refering to another workbook and the workbook's name is save in a variable called FileName1. Below are the code I wrote. Could any one please help?</p>
  
  <pre><code>WbkT3.Worksheets("Finance").Range("G2") = "=VLOOKUP(C2,[" &amp; FileName1 &amp; "]Divisor!$A:$F,3,FALSE)"
  </code></pre>