title: How to insert variable in VBA from another Workbook?
body: <p>Good morning,</p>
  <p>I would like to write in my cell a formula like</p>
  <pre><code>=('[22_07_21_file.xlsm]Daily Report'!$H$59+'[22_07_21_file.xlsm]Daily Report'!$Q$59
  </code></pre>
  <p>But I need to be able to substitute &quot;22_07_21_file&quot; with &quot;File&quot;, defined as:</p>
  <pre><code>File = &quot;&quot; &amp; Year &amp; &quot;_&quot; &amp; Month &amp; &quot;_&quot; &amp; Day &amp; &quot;_&quot; &amp; file &amp; &quot;.xlsm&quot;
  Range(&quot;F32&quot;).Select
  ActiveCell.FormulaR1C1 = _
  &quot;=('[22_07_21_Tagesreport.xlsm]Daily Report'!R59C8+'[22_07_21_Tagesreport.xlsm]Daily 
  Report'!R59C17&quot;
  </code></pre>
  <p>......</p>
  <pre><code>ActiveCell.FormulaR1C1 = _
  &quot;=('[File]Daily Report'!R59C8+'[File]Daily Report'!R59C17&quot;
  </code></pre>