Starting Macro at some future date and time

  • Thread starter Thread starter mmontreuil
  • Start date Start date
M

mmontreuil

I have a database that requires refresh/update each
week. Does anyone know if you start a macro at some
future time? Or maybe be able to open the specific file
at some future time, having the macro start in startup?
I would like to have the database updated first thing in
the morning when I arrive at work. The refresh process
can take some time.

Thanks
 
If you want to run it each time you open the application just put the code
(or a call to it) into a macro named Autoexec.

hth
 
Depending on what OS you have, use Task Scheduler or Scheduled Tasks or AT
service on NT. Have the macro you want to run as the autoexec or use the
command line switch /x macroname.

Steve
 
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

Excel Macro for deleting Rows containing dates greater than "today" 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Scheduled Task 2
Intel based Apple Machines, what happens in the future? 2
Pivot table macro filter data between yesterday and today (date+time) 0
Refresh Query Table causing debug error with Background Refresh pr 2
vba macro that allows insertion of symbols at cursor 0
Background Processing 8

Back
Top