Macro Timer

S

SJW_OST

I have a database in which I use a macro to run multiple queries with. I need
to know how long it is taking the macro to run from the start of the macro
until the end of the macro.

Any help is greatly appreciated.
Stephen
 
D

dch3

You can only do this with VBA basically at the start of the procedure you'll
capture the start time and at the end capture end time as in

dteStartTime = Now

Code: 
dteEndTime = Now

and then subtract the two. Personally, I *never* use macros. If your macro
is such that its quite complex then you can always execute it via the code
DoCmd.RunMacro(?). I would recommend converting it to code as running it via
code is much more durable and allows you to introduce error handling if
something craps out.
 
Top