February 8, 2020
Could someone help me out with VBA code to automatically refresh a query (named "Times") every 30 seconds? I can set it it for one minute but would like the refresh to occur automatically every 30 seconds instead.
On a similar note, I would also like to refresh a query (named "Dates") on a different sheet upon sheet activation. Again, I cannot figure out the VBA code.
November 8, 2013