Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Scheduling macros in excel to run auto

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ewagz - 22 Jan 2006 17:44 GMT
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?
Signature

EW - Analyst

Dave Peterson - 22 Jan 2006 18:18 GMT
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.

> 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

Signature

Dave Peterson

JE McGimpsey - 22 Jan 2006 18:23 GMT
See

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

> 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?
ewagz - 22 Jan 2006 23:31 GMT
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)
Signature

EW - Analyst

> See
>
>     http://cpearson.com/excel/ontime.htm
>
> > 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?
JE McGimpsey - 22 Jan 2006 23:37 GMT
Yes.

> 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)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.