Schedule a macro running

  • Thread starter Thread starter okanem
  • Start date Start date
O

okanem

Is there anyway to schedule a spreadsheet to open and a macro containe
within that spreadsheet to run, daily without user interaction.

Hoping someone has a solution

Okane
 
If excel is already open, you can use the OnTime event.
You can read more at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm

If excel isn't running, you could use a windows scheduler (built into some
versions of windows and lots are free if you search google) to open your
workbook.

You could have the Auto_Open() macro run the procedure that needs to be run.

option explicit
sub auto_open()
call yourmacronamehere
thisworkbook.close savechanges:=true 'false???
end sub

===
And that macro you run can't have any required user interaction, too.
 
Back
Top