[foxboro] Datalink & Excel

Hi List !
I am trying to make some VBA macro for excel in a PC that would store values of 
some pre-determined real time objects (C:B.P) from AW over a period of time. 
Now, to emulate an excel based historian, I need to flood the required cells in 
a col. (using DataLink objectaccess method) at a particular instance, pause for 
some time and then move to the next col. and again flood the similar cells. 
This would continue for some time. The pause period betweem these 2 activities 
(from one col. to the next) would be the scan time for the historian.  I'm 
finding no workable solution to make it pause and move to the next col. w/o 
bothering excel much. VBA's "Wait" method makes excel inaccessible to the user 
PC all along and even slows down the PC. 
Is there any "smarter" solution that can make the things happen in background 
(it would be nice if the excel can also run in background) ?

Thanks and regards,

Sumitava Sen Gupta 

 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: