Re: [foxboro] Datalink & Excel

I have several Excel sheets that do just that. I also have made an Access
database historian to do the same thing. I can send you one. To much code to
post here.
 
-----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>  
  

 
 
_______________________________________________________________________
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: