Re: [foxboro] Datalink & Excel

Hi
There is a function in VB but I don't know  how to work it in excel scrip=
ting.
Here follows:
In general declaration:
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Call that sub:
DoEvents: Sleep 500 ' Sleep 500 msec
Daniel

>>> sumitava@xxxxxxxxxxxxxxxx 25-Apr-02 16:36:03 >>>
Hi List !
I am trying to make some VBA macro for excel in a PC that would store val=
ues of some pre-determined real time objects (C:B.P) from AW over a perio=
d 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 partic=
ular instance, pause for some time and then move to the next col. and aga=
in 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 th=
e 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"=
=20method makes excel inaccessible to the user PC all along and even slow=
s down the PC.=20
Is there any "smarter" solution that can make the things happen in backgr=
ound (it would be nice if the excel can also run in background) ?

Thanks and regards,

Sumitava Sen Gupta=20

=20
=20
_______________________________________________________________________
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=20
=20
foxboro mailing list:             http://www.freelists.org/list/foxboro=20
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin=
=20
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave=
=20
=20

WARNING: This e-mail is being sent from African Products (Pty) Limited, a=
nd is intended for the addressee named above. Any unauthorised use or int=
erception of this e-mail is illegal. The e-mail message or its attachment=
s may contain confidential or privileged information and may not be copie=
d, forwarded or disclosed to any unauthorised person. If you are not the =
named addressee (or person responsible for forwarding the e-mail to the a=
ddressee) please notify us immediately via return e-mail and destroy the =
copy you have received. Save for bona fide company matters, African Produ=
cts (Pty) Limited accepts no responsibility for the opinions or the conte=
nt in this e-mail or its attachments.
 
 
_______________________________________________________________________
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: