title: Copy data from Google Sheet to Excel
body: <p>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.</p>
  
  <p>I merely have a range of data in a Google Sheet that I want to transfer into Excel every few minutes. </p>
  
  <p>Any ideas?</p>