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?