A couple RTD related questions, plus VBA timer object

Hi,

I'm writing VBA macros and using an RTD source written in VC++.
I've got a handle on most of it, but have a few problems.


1. In my macro, I need to run a continuous loop. of the type
do while DoEvents() =
processing ...
loop

I'm able to break out of the loop successfully by using a stop
button, but the RTD data stops coming in once I'm in the loop. Why is
that, and how can I avoid that?

2. Is there a way to use a VB style timer rather than a loop? I can't
believe they omitted the timer from the control toolbox (counting off
time won't work for my purposes).

3. How can I access the classes and methods from RTD source? I have
another Excel sheet with macros that does this, and I can't see what
I'm doing differently. I've tried adding what I thought were the
appropriate addins, to no avail.

any help is greatly appreciated.

Thanks,
Brian


--
blindbl
------------------------------------------------------------------------
blindbl's Profile: http://www.msusenet.com/member.php?userid=1030
View this thread: http://www.msusenet.com/t-1870412552

Brian,

Not sure about the C++ side of this or your other questions, but there's a
timer control on my site here that you could try:

http://www.enhanceddatasystems.com/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

"blindbl" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> I'm writing VBA macros and using an RTD source written in VC++.
> I've got a handle on most of it, but have a few problems.
>
>
> 1. In my macro, I need to run a continuous loop. of the type
> do while DoEvents() =
> processing ...
> loop
>
> I'm able to break out of the loop successfully by using a stop
> button, but the RTD data stops coming in once I'm in the loop. Why is
> that, and how can I avoid that?
>
> 2. Is there a way to use a VB style timer rather than a loop? I can't
> believe they omitted the timer from the control toolbox (counting off
> time won't work for my purposes).
>
> 3. How can I access the classes and methods from RTD source? I have
> another Excel sheet with macros that does this, and I can't see what
> I'm doing differently. I've tried adding what I thought were the
> appropriate addins, to no avail.
>
> any help is greatly appreciated.
>
> Thanks,
> Brian
>
>
> --
> blindbl
> ------------------------------------------------------------------------
> blindbl's Profile: http://www.msusenet.com/member.php?userid=1030
> View this thread: http://www.msusenet.com/t-1870412552
>

Robin,

Thanks ... but it doesn't seem to completely work. I placed the ocx is
the sys32 folder and registered it. I then registered it as a custom
control in Excel using the 'More Controls' panel of the toolbox, after
which it was available as VBAtimer.timer under More Controls (but no
Clock icon on the toolbox). I was able to add it to the form from there
... but it didn't seem to do anything. I checked, it was enabled.

Using the toggle sample program, the current time: message never showed
up. The CmdButton procedure did toggle the timers enable and reset it's
interval though.

Any ideas?

Thx,
Brian


--
blindbl
------------------------------------------------------------------------
blindbl's Profile: http://www.msusenet.com/member.php?userid=1030
View this thread: http://www.msusenet.com/t-1870412552

Brian,

Not really. It's odd that it is showing up in the control list but that the
bitmap is not being added to the toolbox. Do you get an empty picture?
Somehow you need to draw the control onto the form. I have just tested it on
a clean machine in Office 2003 and Win XP and it works fine. Let me know
what version of Excel and Windows and I'll try it on your platform
combination on my test machine and see what happens.

Robin Hammond
www.enhanceddatasystems.com

"blindbl" <[email protected]> wrote in message
news:[email protected]...
>
> Robin,
>
> Thanks ... but it doesn't seem to completely work. I placed the ocx is
> the sys32 folder and registered it. I then registered it as a custom
> control in Excel using the 'More Controls' panel of the toolbox, after
> which it was available as VBAtimer.timer under More Controls (but no
> Clock icon on the toolbox). I was able to add it to the form from there
> .. but it didn't seem to do anything. I checked, it was enabled.
>
> Using the toggle sample program, the current time: message never showed
> up. The CmdButton procedure did toggle the timers enable and reset it's
> interval though.
>
> Any ideas?
>
> Thx,
> Brian
>
>
> --
> blindbl
> ------------------------------------------------------------------------
> blindbl's Profile: http://www.msusenet.com/member.php?userid=1030
> View this thread: http://www.msusenet.com/t-1870412552
>

Just a thought. Did you download the compiled version, or the source code?
If you got the source code version there's a note at the bottom of the web
page about resetting the path to the bitmap which might explain why there is
not image on the toolbox.

Robin Hammond
www.enhanceddatasystems.com

"Robin Hammond" <[email protected]> wrote in message
news:[email protected]...
> Brian,
>
> Not really. It's odd that it is showing up in the control list but that
> the bitmap is not being added to the toolbox. Do you get an empty picture?
> Somehow you need to draw the control onto the form. I have just tested it
> on a clean machine in Office 2003 and Win XP and it works fine. Let me
> know what version of Excel and Windows and I'll try it on your platform
> combination on my test machine and see what happens.
>
> Robin Hammond
> www.enhanceddatasystems.com
>
> "blindbl" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Robin,
>>
>> Thanks ... but it doesn't seem to completely work. I placed the ocx is
>> the sys32 folder and registered it. I then registered it as a custom
>> control in Excel using the 'More Controls' panel of the toolbox, after
>> which it was available as VBAtimer.timer under More Controls (but no
>> Clock icon on the toolbox). I was able to add it to the form from there
>> .. but it didn't seem to do anything. I checked, it was enabled.
>>
>> Using the toggle sample program, the current time: message never showed
>> up. The CmdButton procedure did toggle the timers enable and reset it's
>> interval though.
>>
>> Any ideas?
>>
>> Thx,
>> Brian
>>
>>
>> --
>> blindbl
>> ------------------------------------------------------------------------
>> blindbl's Profile: http://www.msusenet.com/member.php?userid=1030
>> View this thread: http://www.msusenet.com/t-1870412552
>>
>
>