VBA for Weight Scale

Mettler Toledo technical support can be reached at 800-786-0812 or UPS technical assistance at 888-553-1118.

All you need is a computer and the UPS OnLine Office / Worldship shipping software and the PS60 scale.

Simply connect the scale to the PC with the included 10 foot interface cable.

It uses its own software!

Call the company for more help.

I am not using it for UPS, I am doing some testing with it and I need to get the information into excel. If I have a vba I can place a weight on the scale and remove it and it will put the weight in A1. Then repeat and it will put the weight in A2, and so on for the next weight. The cells will change when the scale goes back to zero.

If a cell is being updated by code/formula you can do someting with it like update a Range on another Sheet using that Data Sheets "Calculate Event" if the cell is updated by hand then use the "Change Event" I think you can trap the re-set to zero in the Calculate Event and use it to by-pass updating the data Range on the other sheet to preserve it. I do not have any working code for this, but the above is how I would start?

Did you call the phone number?
You can't be the only person wanting to do this and the company should have some working samples!

Thanks Joe, but Mettler Toledo was no help they just told me they build scales not interface. I can handle the coding for the calculations and updating. I just don't know how to receive the information from the scales vis a USB connection. I have never worked with incoming data not being entered so any help here would be welcomed.

You will likely need a third party control to read from the USB port. I know very little of the standard protocols for data transfer for USB, but I think it appears to resemble IDE. There is hardware available such as "USB Protocol Analysers ". This lends me to believe that the stream may be highly proprietary unlike serial data which can at least be read byte by byte and interpreted. Unless the company that designed your hardware supports an API, you may be in for a very technical ride. Perhaps you may wish to look into a USB to serial converter. If so, then we have some options available to us. If not...?

Maybe you can contact the weight scale seller for more information about this

beckylam said:

Maybe you can contact the weight scale seller for more information about this

Click to expand...

I also met this problem for my weight scale.Oh, no