I've created a real-time predictive model engine using excel as the
platform.

I use a real-time database built inside excel using part static data
and part live data through a real-time DDE feed from a third party. I
have no problem running macros that update any of my databases
containing data for one day and up (Weekly, Monthly, etc.).

However, I now need to build 6 more real-time databases in excel with
Time Intervals LESS than 1 day. This means Intra-Day updates of the
data using the update Macros. Doing this manually would be a real pain
and not very practical to boot.

I need to update these new databases in real-time at SPECIFIC time
intervals (i.e., 5 min, 10 min, 15 min, 30 min, 2 hours, and 4 hours)
and I don't want to have to sit in front of the computer running manual
macros all day long.

I need a way to execute the macros responsible for doing the database
updates *every “X “number of minutes* WITHOUT having that sheet
containing the macro in state condition (i.e., active and visible on
screen).

So, I need a *“Macro Timer”* of sorts that will run in the background
at fixed time intervals while allowing me to continue working in other
excel sheets/workbooks.

Possible - or Pipe Dream?

Thanks a bunch!
MacroOnTime


--
MacroOnTime
------------------------------------------------------------------------
MacroOnTime's Profile: http://www.excelforum.com/member.php...o&userid=24167
View this thread: http://www.excelforum.com/showthread...hreadid=377955

Hello MacroOnTime,

You need an API Timer. I have the macro code for this. This will run i
the background and allow you to work on other things. However, th
workbook must remain Open for the timer to work since it is called fro
VBA. If this will work for you, contact me via e-mail and I can e-mai
the code to you. Please include the version of Office you are using. M
e-mail is .

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=37795

Try this link from ExcelTip

Simon

http://www.exceltip.com/st/Execute_C...n_VBA/763.html


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=377955

Nope avoid OnTime and stick with api SetTimer
http://www.cpearson.com/excel/ontime.htm



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Simon Lloyd wrote :


Try this link from ExcelTip

Simon

http://www.exceltip.com/st/Execute_C..._Using_Timer_i
n_VBA/763.html

For what you want to do, XL's OnTime method is probably the easiest to
you. See http://www.cpearson.com/excel/ontime.htm, which, in addition
to describing the OnTime method, also describes the API timer routines.
Do be aware that there are differences in how the two behave.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I've created a real-time predictive model engine using excel as the
platform.

I use a real-time database built inside excel using part static data
and part live data through a real-time DDE feed from a third party. I
have no problem running macros that update any of my databases
containing data for one day and up (Weekly, Monthly, etc.).

However, I now need to build 6 more real-time databases in excel with
Time Intervals LESS than 1 day. This means Intra-Day updates of the
data using the update Macros. Doing this manually would be a real pain
and not very practical to boot.

I need to update these new databases in real-time at SPECIFIC time
intervals (i.e., 5 min, 10 min, 15 min, 30 min, 2 hours, and 4 hours)
and I don't want to have to sit in front of the computer running manual
macros all day long.

I need a way to execute the macros responsible for doing the database
updates *every =3FX =3Fnumber of minutes* WITHOUT having that sheet
containing the macro in state condition (i.e., active and visible on
screen).

So, I need a *=3FMacro Timer=3F* of sorts that will run in the background
at fixed time intervals while allowing me to continue working in other
excel sheets/workbooks.

Possible - or Pipe Dream?

Thanks a bunch!
MacroOnTime


--
MacroOnTime
------------------------------------------------------------------------
MacroOnTime's Profile: http://www.excelforum.com/member.php...o&userid=24167
View this thread: http://www.excelforum.com/showthread...hreadid=377955