R
Hello, I'm using the "ontime" VBA function to query data (about 100 registers, read through the serial port with an activeX driver) from a PLC every 10
seconds and store it in consecutive worksheet rows. I limit the sheet size to 1000 rows, retaining only the last 1000 samples. Trouble is, the computer gradually begins slowing down and the system clock slows down, so that after 10-12 hours the clock is 1 hour behind and the computer is so slow that it needs rebooting.
My PC is not the latest - a compaq laptop, 266MHz PII, 64 MB RAM - but for this application (maintaining a 100 column by 1000 row data table) I would guess it
should be enough. Any ideas or comments will be gratefully received.
(BTW, I'm using Excel 2000)
Rogelio
seconds and store it in consecutive worksheet rows. I limit the sheet size to 1000 rows, retaining only the last 1000 samples. Trouble is, the computer gradually begins slowing down and the system clock slows down, so that after 10-12 hours the clock is 1 hour behind and the computer is so slow that it needs rebooting.
My PC is not the latest - a compaq laptop, 266MHz PII, 64 MB RAM - but for this application (maintaining a 100 column by 1000 row data table) I would guess it
should be enough. Any ideas or comments will be gratefully received.
(BTW, I'm using Excel 2000)
Rogelio