title: Use Excel VBA to open an Excel file on a LiveLink server
body: <p>I am working on consolidating some monthly reports from different lines of business into one report for month end reporting. Currently I have to open each Excel file one at a time. This takes a while and my time could be be better used elsewhere so I decided to try to add automation to my process.</p>
  
  <p>My reports are stored on a LiveLink server. Obviously the URL path does not reference the folder structure because LiveLink uses the ObjID. My data moves from folder to folder each month and I can handle that in my code. The issue I am having is I can't seem to figure out how to structure the .Open statement so that my file opens.</p>
  
  <p>For example the URL for my file is:</p>
  
  <pre><code>http://discovery.[COMPANY].com/discovery/livelink/85587298/Book1.xlsx
  </code></pre>
  
  <p>My understanding is that I would have to use <code>LiveLinkDav</code> in my .Open statement. So the code I tried was:</p>
  
  <pre><code>Workbooks.open "http://discovery.[COMPANY].com/discovery/livelinkdav/[COMPANY]/[ID]/[DEPARTMENT]/[GROUP]/Book1.xlsx"
  </code></pre>
  
  <p>Excel brings up a status box like it is trying to open but the final result is a file called Book1 with a tab Book1 instead of the file on the server. I have tried a few versions of this with the same result. The drop down showing the folder structure is as follows:</p>
  
  <pre><code>Library
    [Company]
      [ID]
        [Department]
          [Group]
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>