First of all let me state that my coding ability is very limited.
I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1.
What I want to due is create a macro to calculate the mass rate of change (i.e. pounds per minute) by reading scale value, wait 5 seconds, read scale value again. Take change in weight divided by change in time.
Would also be nice to have a couple of active x controls to start/stop calculation. I know how to add the controls but do not know how to code them.
Thanks in advance.
I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1.
What I want to due is create a macro to calculate the mass rate of change (i.e. pounds per minute) by reading scale value, wait 5 seconds, read scale value again. Take change in weight divided by change in time.
Would also be nice to have a couple of active x controls to start/stop calculation. I know how to add the controls but do not know how to code them.
Thanks in advance.
