I have some
VB code that reads about 20 tags from a PLC and communicate
through DDE. The code contantly collects data from these tags and lay
them out in excel. From there I use Lists to select which data colum
I want to read.
Everything works fine with my code except that once I start the macro
have no way of stopping it other than hitting ctrl + break. I woul
rather not have the users stopping the data collection this way but I'
not sure of a solution.
I want to use a stop toggle button , but I don't think I could push i
while the macro is running (the working hourglass is up).
Anyone have any solutions
--
pete358
-----------------------------------------------------------------------
pete3589's Profile:
http://www.excelforum.com/member.php...fo&userid=2840
View this thread:
http://www.excelforum.com/showthread.php?threadid=48394