Hello to all,
A contractor has written a horsepower calculation using Excel 2000 VBA. My responsibility is to DDE data in and out of the spreadsheet to a PLC5 via RSLinx. I have been sucsessful creating a pushbutton that does just this.
My problem is I want automate the pushbutton code on a routine basis without operator interaction. My experience with VB tells me to use a timer to call the pushbutton code, but Excel VBA dosn't appear to have a timer control. I tried to add the control to the existing controls list, but it doesn't appear.
When I try to create my own timer and loop the pushbutton code, it consumes all the application resourses and appears to lock up. When I step though each line of code it works, but as soon as I run the code I get the same lock-up.
Does any one know how I can get the timer control for Excel or create a timer that won't consume the resourses?
Thanks in advance
Bill
A contractor has written a horsepower calculation using Excel 2000 VBA. My responsibility is to DDE data in and out of the spreadsheet to a PLC5 via RSLinx. I have been sucsessful creating a pushbutton that does just this.
My problem is I want automate the pushbutton code on a routine basis without operator interaction. My experience with VB tells me to use a timer to call the pushbutton code, but Excel VBA dosn't appear to have a timer control. I tried to add the control to the existing controls list, but it doesn't appear.
When I try to create my own timer and loop the pushbutton code, it consumes all the application resourses and appears to lock up. When I step though each line of code it works, but as soon as I run the code I get the same lock-up.
Does any one know how I can get the timer control for Excel or create a timer that won't consume the resourses?
Thanks in advance
Bill