Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Data from a Com Port or Printer Port
How would I go about capturing the data sent via a port into a excell spread
sheet by clicking on the cell ?? Can any one help me , Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Data from a Com Port or Printer Port
If you are using a bar code reader, many of these come with a utility which
will stuff the input into the keyboard buffer - then all you have to do is select the cell so it has the focus for keystrokes, then read the code. The utility adds in a CR at the end of the stream -- Regards, Tom Ogilvy "Newby :)" <Newby wrote in message ... How would I go about capturing the data sent via a port into a excell spread sheet by clicking on the cell ?? Can any one help me , Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Data from a Com Port or Printer Port
Thank you but this does not help me , how do i go about achieving this ???
I am wanting to pull the data from a digital scale but want to via a macro or other means to be able to when I click on a cell it must read the data and put it in a cell. "Tom Ogilvy" wrote: If you are using a bar code reader, many of these come with a utility which will stuff the input into the keyboard buffer - then all you have to do is select the cell so it has the focus for keystrokes, then read the code. The utility adds in a CR at the end of the stream -- Regards, Tom Ogilvy "Newby :)" <Newby wrote in message ... How would I go about capturing the data sent via a port into a excell spread sheet by clicking on the cell ?? Can any one help me , Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Data from a Com Port or Printer Port
The best place to ask would be the makers of the digital scale.
A previous answer to a similar question: =================== posted by eric in programming 10/27/2003 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. --------------------------------------- Here is a link to some general information on the MSComm control: http://www.yes-tele.com/mscomm.html --------------------------------------- Another Option: Unfortunately Excel makes it almost impossible to do serial communications directly using VBA. Fortunately there are other easy solutions for inputting serial data into Excel from devices like scales, measuring tools and bar code readers. The company that I work for sells a serial communications program called the Software Wedge that you may find to be a good tool for adding serial communications capabilities to your application. The Software Wedge is an executable program that can pass serial data back and forth to other programs using either DDE (Dynamic Data Exchange) or by converting incoming serial data to keystrokes (i.e. it stuffs the keyboard buffer with the incoming serial data). The program is extremely easy to use and is designed to have you up and running sending and receiving serial data directly from within your application in just a few minutes. Please visit http://www.taltech.com for more information. ------------------------------------------ This link has some free utilities from TalTech: http://www.taltech.com/freesoftware/fs_sw.htm ------------------------------------------- Fred Cummings Excel page has information on the serial port interface with Excel: http://fcfhsp.customer.netspace.net.au/xlhome.htm ------------------------------------------ Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Newby :)" wrote in message ... Thank you but this does not help me , how do i go about achieving this ??? I am wanting to pull the data from a digital scale but want to via a macro or other means to be able to when I click on a cell it must read the data and put it in a cell. "Tom Ogilvy" wrote: If you are using a bar code reader, many of these come with a utility which will stuff the input into the keyboard buffer - then all you have to do is select the cell so it has the focus for keystrokes, then read the code. The utility adds in a CR at the end of the stream -- Regards, Tom Ogilvy "Newby :)" <Newby wrote in message ... How would I go about capturing the data sent via a port into a excell spread sheet by clicking on the cell ?? Can any one help me , Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printer Using USB Port Slows Page Setup | Excel Discussion (Misc queries) | |||
Receiving data from a Lan Port | Excel Programming | |||
probing the serial port for data | Excel Programming | |||
reading data from com port into excel spreadsheet | Excel Programming | |||
serial port data acquisition | Excel Programming |