Macro run history

  • Thread starter Thread starter dapper
  • Start date Start date
D

dapper

Is there a way to keep track of when the macros run? Like date and time?
 
Dapper,

You could make a table in your database to store this information. And then
you could include an OpenQuery action in your macro, to run an Append Query
which writes the date/time into the table.
 
You could have each macro to include an action to append a record to a table
indicating macro name and datetime of occurance.
 
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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Run Macro If Cell have "x" value 0
Pivot table macro filter data between yesterday and today (date+time) 0
Repeat macro until record count of query = 0 0
Windows XP Prohibit record run history 0
Run macro on startup only if it has not been run previously today 1
Word macro based on following text 3
Folder Rename Macro / bat file simple? (I hope) 1

Back
Top