ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Capture RS232 data (https://www.excelbanter.com/excel-worksheet-functions/111764-capture-rs232-data.html)

Michelle

Capture RS232 data
 
Hello, I work with a system that prints out receipts on a dedicated little
printer whenever there is a transaction.

I want to be able to capture the information onto a laptop that I plug in
instead of the printer, and end up with it all in an Excel spreadsheet.

The printer connects to a multi-pin socket that looks like a COM port.
The data comes out (and I don't know what any of this means) as RS232, 1200
baud rate, with 8 data bits, 1 stop bit and no parity.

Can I get it dumped to disk in a format that Excel can read?

Should I have posted this in another newsgroup? If so, can anyone tell me
which one - I am a complete beginner when it comes to this kind of thing.

Many thanks



Bernie Deitrick

Capture RS232 data
 
Michelle,

Do a google search on WinWedge - it's a great product, and works well with all the devices I have
used it with.

HTH,
Bernie
MS Excel MVP


"Michelle" wrote in message
...
Hello, I work with a system that prints out receipts on a dedicated little printer whenever there
is a transaction.

I want to be able to capture the information onto a laptop that I plug in instead of the printer,
and end up with it all in an Excel spreadsheet.

The printer connects to a multi-pin socket that looks like a COM port.
The data comes out (and I don't know what any of this means) as RS232, 1200 baud rate, with 8 data
bits, 1 stop bit and no parity.

Can I get it dumped to disk in a format that Excel can read?

Should I have posted this in another newsgroup? If so, can anyone tell me which one - I am a
complete beginner when it comes to this kind of thing.

Many thanks





All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com