question

JoseAbasoloDelgado-2645 avatar image
0 Votes"
JoseAbasoloDelgado-2645 asked DSPatrick edited

Import Excel sheet from Sharepoint with VBA

Hi everybody,
An app created with PowerApps sends data to an Excel sheet allocated in Sharepoint.
I have an .xlsm with an app in VBA in my desktop Excel to manage these data, make queries, sort results, etc.
To do this, I have to open the Sharepoint sheet, and then copy and paste in a worksheet of my desktop workbook so I can take control. This is annoying as there are a number of people adding data to Sharepoint constantly, so I have to refresh very frequently.
I have tried with "ActiveWorkbook.Queries.Add" and it only works when seeking in OneDrive, but it doesn't in Sharepoint
Is there any way to import from Sharepoint via VBA? Or even have access to it online?
Thank you
Josetxu.

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers