Run a macro/VBA every 5 seconds
<p>On an excel worksheet I have created several SQL Queries using Microsoft Power Query,
These queries should be refreshed every 5 seconds so new information is retrieved from a SQ database.</p>

<p>To Refresh , I go to the Data Tab in Excel and hit the Refresh All button which refreshes all workbooks.This works good</p>

<p>I want to automate this request every 5 seconds
Ideally,A macro should run the command Ctrl+Alt+F5 every 5 seconds in the background.</p>

<p>How can I achieve this</p>