Forum Discussion
Getting updated data from a Microsoft Form's SharePoint Excel Repository using VBA.
Use Power Automate to open the file (even a dummy step like reading the file) — this forces SharePoint to sync the latest Form responses before your VBA runs. If you’re sticking with VBA only, you’d have to manually open the file in Excel Online or on your PC before running the macro. There’s no purely VBA method to trigger the sync automatically.
piper977 , could you please share bit more details. Did you use desktop flow or cloud flow and which exactly steps. At least with cloud flow I was not able to push syncing the file.
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.
piper977 , thank you, but that doesn't work in my case. Run the flow with step you mentioned. In a while Power Query this file, it is not synced. Will try to play more in a while.
