P
pete3589
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
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