How to reference online workbook in VBA
<p>Stuck on trying to reference a workbook which is on SharePoint.</p>

<p>I can use this to open the file:</p>

<pre><code>Workbooks.Open("http://www.website.com/File.xlsx")
</code></pre>

<p>However, I want to execute without opening the file... is there a way to utilize that online workbook without opening?</p>

<p>I have tried (had to split out the string to multiple lines so it would show up like code): </p>

<pre><code>Workbooks("http://www.website.com/File.xlsx")._
Sheets("Sheet1").Range("A1").Value
</code></pre>

<p>references and get errors if I try to add a website to the Workbooks section (typically run-time error 9, subscript out of range).  I have had the same error in trying to define the workbook beforehand:</p>

<pre><code>Dim wbk as Workbook
Set wbk = Workbooks("http://www.website.com/File.xlsx")
</code></pre>

<p>Any help would be appreciated!</p>