reading serial data into an Excel spreadsheet is an extremely
difficult thing to do using VBA code in a macro. It requires some very
complex calls to the Windows API and although I am certain that it is
possible, the amount of effort required to do so would be extensive
and probably not worth it.
A better way to go would be to use an off the shelf tool that is
designed for this type of job.
The best one that I know of is called WinWedge from TAL Technologies.'
You can learn more about WinWedge at the following URL:
http://www.taltech.com/products/winwedge.html

WinWedge basically makes it extremely easy to both send and receive
RS232 data directly from within an Excel spreadsheet.


On 10 Feb 2005 09:48:00 -0800, "Franz"
wrote:

Is there anyone that could help me to read the com port into an excel
worksheet via a macro?

FB