I want to essentially run a VBA Macro every few minutes with information from a Google Sheet. I have tried using the "Publish to web" option, but it takes more than 5 minutes to refresh due to the size of the data. I also don't want to export or save as an Excel doc every few minutes as this needs to be automated. I also don't want to use RPA.
I merely have a range of data in a Google Sheet that I want to transfer into Excel every few minutes.
Any ideas?