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