Run Macro for 2 minutes, stop, refresh queries for 10 seconds and then Loop back to Macro

J

jland

New Member
Joined
Dec 21, 2017
Messages
4
I have an Excel file with 3 tabs that are all pulling info through queries which rotate every 40 seconds. The VBA I have for it works great.
After rotating through the tabs I need the queries to refresh via VBA.
However, since a macro is being ran, the queries wont refresh until I manually stop the macro.
I need help with a macro to:
Run my "TabRotation" for 2 minutes, stop and allow the queries to "RefreshAll" for 5-10 seconds and then loop back and begin the rotation again.

Any help would be greatly appreciated!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

J
  • Question
Power Query - Data Refresh Error in Macro
Replies
3
Views
132
bobsan42
bobsan42
Z
  • Solved
MSGBox for VBA Error
Replies
4
Views
336
Joe4
Joe4
K
  • Solved
VBA that runs Sub after Data Refresh All completes
2
Replies
11
Views
2K
John_w
J
V
  • Question
Looking to create VBA command to go through List of sheet names, look up sheet name in range, look up value in cell next to it, and run a macro
Replies
3
Views
101
Volrin
V
JeffGrant
  • Question
Does xlCalculationState change when running PQ?
Replies
0
Views
107
JeffGrant
JeffGrant

Forum statistics

Threads
1,214,832
Messages
6,121,854
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top