Macro Timer

  • Thread starter Thread starter SJW_OST
  • Start date Start date
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
 
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.
 
Back
Top