Scheduling macros to run automatically

  • Thread starter Thread starter meera chandan
  • Start date Start date
M

meera chandan

Hi

I have a whole set of macros that i need to run everyday
at work that takes about 1.5 hrs to run... Is there anyway
that I can schedule certain macros to run at certain times
during the day everyday? Can this be done in Excel or do
we need to use VB professional to program something like
this? I would appreciate any help with this because I do
not know where to start with this.

Thanks,
Meera
 
Look at Chip Pearson's application.ontime example

http://www.cpearson.com/excel/ontime.htm

You can use the workbook_Open event to run code when a workbook is opened

you can use the window's schedular to have windows open a workbook/start
excel at a certain time.
 
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

Scheduling a Macro to Run 6
automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
run addin function from macro 3
Scheduling a Macro 4
Scheduling Macro run 1
Running a macros every Monday, Wednesday, and Friday 1
Time Marco issue 2

Back
Top