Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Capture RS232 data

All you need to do is to re-direct your printing from the RS-232 or
Centronics port to an internal file.

Start Settings... Printers Add a Printer
when the wizard asks to you assign a port, pick
FILE(print to file)
--
Gary's Student


"Michelle" wrote:

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



  #3   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Capture RS232 data

I'm sorry, I didn't make it clear. The data doesn't come from a computer, it
comes from a piece of dedicated machinery, and I want to plug a computer in
in place of the printer, to capture the data into a file instead of getting
printed.

Thanks

M


"Gary''s Student" wrote in message
...
All you need to do is to re-direct your printing from the RS-232 or
Centronics port to an internal file.

Start Settings... Printers Add a Printer
when the wizard asks to you assign a port, pick
FILE(print to file)
--
Gary's Student


"Michelle" wrote:

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Formula to capture data on a date and preserve it Jeff Excel Worksheet Functions 0 October 11th 05 11:18 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"