VBA workbooks.open opening file but is blank

[grabrail]

Hi

I am trying to create a macro, that opens an excel file from Sharepoint, then selects some specific data and copies it to my current workbook

First task, open excel file from Sharepoint.

I use the code

workbooks.open "..url to file"

And run the macro, this runs and opens a workbook with the title I have entered in the URL but it appears to be a new file with 1 worksheet (file on sharepoint has multiple worksheets) that is completely blank

I have put the url i have into the browser bar and it opens the file with all data no problem

Any ideas?

 

[grabrail]

Sorted it, hopefully to help anyone else that has a similar issue

Don't use the Share Link as your URL, look at the details of the file on sharepoint, at the bottom of the details panel, there is a path section, copy the path from here.