title: Path to sheet on a workbook over IP address?
body: <p>I want to update my sheet with content from another sheet on another workbook. That workbook is in shared <code>SharedFolder</code> on a network. So, I'll be using <code>FormulaR1C1</code> to reference that sheet. </p>
  
  <p>Currently that sheet is on the same workbook and I'm referencing to it like this:</p>
  
  <pre><code>.FormulaR1C1 = "=IFERROR(VLOOKUP(RC2,BE!C1:C15,3,FALSE),"""")"
  </code></pre>
  
  <p>If content of my current sheet is in workbook in <code>SharedFolder</code> how could I reference to it over <code>IP</code> address?</p>
  
  <p>I'm able to do this, which is similar to scenario that I need:</p>
  
  <p><img src="https://i.stack.imgur.com/OLJJA.jpg" alt="enter image description here"></p>
  
  <p>here I'm referencing to an excel file on mapped network drive(Z:). As you can see this is done through formula bar. I need something like this but in <code>VBA</code> and over <code>IP</code> address.</p>
  
  <p>Thanks.</p>