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...