How stable is Excel using timed loops
 

For a Business application I want to read some XML file every minute.
The idea is that it retains these events for 30 min.
So basically every minute I:
1) read XML (1 to 400 records)
2) process the XML to add some data to it
3) remove events older than 30 min
4) display graphs tables etc based on the leftover records.

As the idea is to run this 24x7 I need to know if someone has experience
with the stability of Excel

thanks in advance

How stable is Excel using timed loops
 

Ron,

Excel can be very stable for reading telimetry data from the internet. BUT,
you must do a lot of error checking and loging because your XML information
will not always be what you expect. Otherwise you will could crash when you
get blank garbeled data. Write your code, then when you think your code is
perfect, add "On Error Resume Next" in every routine and test, test, test.

Allan P. London, CPA


"Ron" wrote in message
...
For a Business application I want to read some XML file every minute.
The idea is that it retains these events for 30 min.
So basically every minute I:
1) read XML (1 to 400 records)
2) process the XML to add some data to it
3) remove events older than 30 min
4) display graphs tables etc based on the leftover records.

As the idea is to run this 24x7 I need to know if someone has experience
with the stability of Excel

thanks in advance

How stable is Excel using timed loops
 

This is a very bad idea. Excel is great as a desktop productivity
application, but it's not a server application, it does not stand up well to
24x7 usage.

If you have to do this then do not use application.ontime, investigate the
Windows Api call settimer.


--
www.alignment-systems.com


"Ron" wrote:

For a Business application I want to read some XML file every minute.
The idea is that it retains these events for 30 min.
So basically every minute I:
1) read XML (1 to 400 records)
2) process the XML to add some data to it
3) remove events older than 30 min
4) display graphs tables etc based on the leftover records.

As the idea is to run this 24x7 I need to know if someone has experience
with the stability of Excel

thanks in advance