Execute macro to run automatically

  • Thread starter Thread starter rakshan syed
  • Start date Start date
R

rakshan syed

Hi,

I have created a pivot chart in excel that i want to
refresh data everyday. I have created a macro to refresh
the data and save that file. I want to be able to schedule
this macro on a scheduler to run automatically everyday.
Can any one help me with that.

Thanks,
Rakshan
 
rakshan

See Chip Pearson's site for coding with the OnTime method.

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

Note: you can also use Windows Task Scheduler to open Excel and run a
Workbook_Open Macro then save and close Excel if you wanted to do this at some
time when computer is idle.

Gord Dibben Excel MVP
 

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 Automatically When Excel 2003 Opens 2
Schedule Macro doesn't seem to run any suggestions 3
Import data and macro 5
Running a macro based on the time 1
Run Macro when changing tabs 2
copy data from one excel workbook to another workbook using macro 4
How to code VBA: Auto open workbook and run macro 4
Running excel macro by scheduler 1

Back
Top