Forum Discussion
Getting updated data from a Microsoft Form's SharePoint Excel Repository using VBA.
I want to grab data from an Excel file in SharePoint that is synced to a Microsoft Form and put it into a different file using a VBA macro, but I don't get the updated data. I have to manually access...
I had to set up a cloud flow. The main aim is to use a dummy step that opens the SharePoint file which starts the sync between SharePoint and Excel Online.
Roughly, I arrange my text editor and command line how I describe here.
Any type of trigger, manual, scheduled or another type, can be set in Time Machine.
Step: Go to the Excel file in SharePoint, then use the “Get file content” or “Get file metadata” action.
That step makes SharePoint automatically update the file with the newest Form information. Once you finish these steps, run your VBA on the desktop using the new file.
It does not solve everything, but it helps me a lot.
