Scheduling macros in excel to run auto
 

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction. Is there a code for this?
--
EW - Analyst

Scheduling macros in excel to run auto
 

Chip Pearson describes how to use OnTime:
http://www.cpearson.com/excel/ontime.htm

But you may have to change your macros to avoid interaction.

ewagz wrote:

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction. Is there a code for this?
--
EW - Analyst

--

Dave Peterson

Scheduling macros in excel to run auto
 

See

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

In article ,
"ewagz" wrote:

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction. Is there a code for this?

Scheduling macros in excel to run auto
 

Would this also fit if I were looking at certain times of the hour to have
this run....if I were to have this run 10 min past the half hour (1:10 and
then again at 1:40)
--
EW - Analyst


"JE McGimpsey" wrote:

See

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

In article ,
"ewagz" wrote:

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction. Is there a code for this?

Scheduling macros in excel to run auto
 

Yes.

In article ,
"ewagz" wrote:

Would this also fit if I were looking at certain times of the hour to have
this run....if I were to have this run 10 min past the half hour (1:10 and
then again at 1:40)