In the VBE, create a userform. Next, create a
communications control (Microsoft Communications Control,
version x.x) and name it Comm1.
In the properties window of the communications control,
see what the name is. We'll name this one comExcel for the
examples below.
Then in a module, type:
Comm1.comExcel.CommPort = [Enter the com port here]
Comm1.comExcel.Settings = "9600,n,8,1" 'enter your own for
your device
Comm1.comExcel.PortOpen = True 'opens the port
Comm1.comExcel.Output = anything that needs to read from
the computer to the PC
Use at your own risk!!!! This code works for our weight
scales, but you'll have to read your manual to get the
output you desire. If anyone has any other suggestions,
please feel free.
