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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Pasting cell contents into a macro 1
Shape Arrays VBA 0
Excel TWO Instances of Excel One watching Other 3
2501 The OpenQuery action was canceled. 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Access: "global" timer 2
Excel Macro for deleting Rows containing dates greater than "today" 0

Back
Top