' You haven't declared any of your variables ' Code to get data from Digimatic Indicatorīut yes - I need a way to stop the code in between readings to allow the user to play around, the a way for them to restart and have the macro pick up where it left off. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ ' Special Paste Actual time into I21 to keep as a fixed baseline and avoid continual refreshing It would be better to send the spreadsheet as just the macro doesn't give you the full picture - be here it is : It sucks the resources hard by using the NOW() function though. Then it needs to be able to resume and start looking at the clock to see if it's time for the next reading. I need them to be able to stop/pause the macro to do what they want in between readings - which can be hours or even days. Since the NOW() function is running non stop, the spreadsheet can't be broken into easily by the user.
It starts the NOW() function to make a clock/timer then adds the user defined time intervals at which it has to go fetch the reading from the instrument with some DDE code and a program called WinWedge (by Taltech). The spreadsheet is logging RS232 input from digital indicators that measure deflection.
0 kommentar(er)
