-----Original Message----- From: Sumitava Sen Gupta [mailto:sumitava@xxxxxxxxxxxxxxxx] Sent: Thu 4/25/2002 10:36 AM To: foxboro@xxxxxxxxxxxxx Cc: Subject: [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 <http://www.thecassandraproject.org/disclaimer.html> foxboro mailing list: http://www.freelists.org/list/foxboro <http://www.freelists.org/list/foxboro> to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join <mailto:foxboro-request@xxxxxxxxxxxxx?subject=join> to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave <mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave> -- No attachments (even text) are allowed -- -- Type: application/vnd.ms-excel -- File: =?utf-8?B?QXV0byBEYXRhIENvcHkueGxz?= _______________________________________________________________________ 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