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 sto
button, but the RTD data stops coming in once I'm in the loop. Why i
that, and how can I avoid that?

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

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

any help is greatly appreciated.

Thanks,
Bria

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

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" wrote in message
...

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 i
the sys32 folder and registered it. I then registered it as a custo
control in Excel using the 'More Controls' panel of the toolbox, afte
which it was available as VBAtimer.timer under More Controls (but n
Clock icon on the toolbox). I was able to add it to the form from ther
... but it didn't seem to do anything. I checked, it was enabled.

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

Any ideas?

Thx,
Bria

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

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" wrote in message
...

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" wrote in message
...
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" wrote in message
...

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