Connecting to comm1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to get excel to connect to comm1. I have a timmer I have hooked up and want to get the times off of it to a cell in Excel. If someone could help that would be great. Thanks
 
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.
 
Back
Top