Re: [foxboro] Datalink & Excel


Sumitava:

I have a small program written over in VB for similar purpose. I have a
couple of sheets residing in couple of Excel workbooks.

One of the sheets is a source sheet which is getting the data from AW
through DDE, VB reads this sheet every couple of seconds, puts this value
in couple of other sheets, which shows trends, maximum, minimum etc over a
period of shift.

The code consists of couple of modules in VB, and though quite specific to
my requirements, but can be easily modified without much fuss. If u want i
could mail u to the code & excel files.


Regards



Ajay Tathgir
Reliance Industries Limited
Mumbai - India





"Sumitava Sen Gupta" <sumitava@xxxxxxxxxxxxxxxx>@freelists.org on
25-04-2002 20:06:03

Please respond to foxboro@xxxxxxxxxxxxx

Sent by:  foxboro-bounce@xxxxxxxxxxxxx


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

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




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