Re: [foxboro] Datalink & Excel

Hi, can you send it to me too?

Thanks,

Normand

----- Original Message -----
From: <Currie>; "Charles T." <ctcurrie@xxxxxxxxxxxxxx>
To: <foxboro@xxxxxxxxxxxxx>
Sent: Thursday, April 25, 2002 1:11 PM
Subject: 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
>
>
 
 
_______________________________________________________________________
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: