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
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?
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
VBA 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?