Vba download and open file from sharepoint

Hi, I use the below code, to open the latest file from a folder or subfolder. Works great, easy to adapt to different folder situations and file name components.

So I commented it out here. Where is my mistake? Is there any other adaptation necessary? Or is there an alternative approach available? Dir works on local file system. An online sharepoint folder is not local, it's online obviously. Easiest way is to go online to that folder, and sync it to local computer, you should find a Sync command in the menu for this. Then you can use dir to look into the location on your computer where the sync'd folder is. With synced folder you still have the data available even when not online, with mapped folder you need to be online to get the data.

Hi All Please note that at the Chandoo. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. Thread starter xlsvba87 Start date Aug 31, Chihiro Excel Ninja. See link for very handy code. I use small batch file to fire Windows PowerShell script on schedule.

Chihiro said:. Here you go. Range "a1" rng. Offset 0, 1. Offset 0, 2. Files rng. Name rng. We moved to new location. A million permutations, and none of them work. I do not want to open a locally-cached copy, it needs to be the server version. Please, someone show me how to do this.

It can't be this complicated! Excel Facts. Click here to reveal answer. The Roman numeral for 40 is XL. Doesn't anyone know how to open a file located on a Sharepoint server from VBA? Fraxav New Member. In a very simplistic attempt to do something similar, I found that treating it as a local folder seems to work to open a dialog box: VBA Code:. FileDialog 3. Just like you I also tried every one of those steps to alter the URL that I found on various posts from this forum and others.

I finally came across a post that provided a breakthrough solution after all the failed attempts at changing the SP file url. The url I was passing to Workbooks.