64 - Use VBA to update queries, and measure the time it took

Published: 27 March 2024
on channel: WesleySon
30
1

A simple macro that updates all / specific query/queries, and measures how long it took.
You could make the start and difference variables be long-datatype to save like 24 bytes of memory + avoid storing milliseconds. Honestly I just write "dim start" whenever I make a macro like this.

00:50 Disable background queries
01:36 The code
04:12 Teaser