1. Resume In Excel Format

Hi,Use NETComm.ocx. Set the properties in the Load event, and open the port. On further reading of your question.

Can anyone help with communicating to a COM port through Excel (on a machine. For example, a timer can be used to poll the serial port using GetNumBytes. On Error Resume Next 'sometimes the timer is NOT running.

I suppose what you really want to do is to change data in the Worksheet? If so, then you would not try to do anthing with the Keyboard, but would simply change Worksheet cell content by parsingreceive data and making the appropriate changes. Again, I have simple examples for this, but the actual details will depend on things that I don't know about how you want you program to work.Dick Grier. Author of Visual Basic Programmer's Guide to Serial Communications 4. See www.hardandsoftware.net.

Hello Dick,I have a remote temperature monitor that is connected to my computervia RS232 to COM1.Small records of 10-15 charracters are sent per communication.They arrive to COM1 of my computer. They terminate with a carriage-return.I can receive the data with Hyper Terminal program of XP.If I could direct the data to EXCEL then I could resume with the data collection.I can create a program to write the data in EXCEL format in a file butthat is not my intention.There is no editing since the device is just an automated hardware.Thank you,Harry. Hi,Use NETComm.ocx. Set the properties in the Load event, and open the port.

• Harry Stanton. Very skilled Excel Specialist has strong knowledge of and experience with utilizing vLookups sorting and filtering.Has excellent understanding of Excel data item and project status report compiling.Has an Associate’s of Sciences degree in Information Technology certification as an Excel Specialist through Microsoft and five years.
• ASComm.NET Excel Add-in requires one Excel Add-in license for each configured driver per PC that the Excel Add-in will run on. For example, to run ASComm.NET Excel Add-in with the Allen-Bradley ControlLogix Ethernet driver on five PCs, you would purchase an ASCOMM-AB.LOGIX.NET-EX-5 five license package for $996.

Hi,Use NETComm.ocx. Set the properties in the Load event, and open the port. On further reading of your question. I suppose what you really want to do is to change data in the Worksheet? If so, then you would not try to do anthing with the Keyboard, but would simply change Worksheet cell content by parsingreceive data and making the appropriate changes.

Again, I have simple examples for this, but the actual details will depend on things that I don't know about how you want you program to work.Dick Grier. Author of Visual Basic Programmer's Guide to Serial Communications 4. See www.hardandsoftware.net. Hello Dick,I have a remote temperature monitor that is connected to my computervia RS232 to COM1.Small records of 10-15 charracters are sent per communication.They arrive to COM1 of my computer. They terminate with a carriage-return.I can receive the data with Hyper Terminal program of XP.If I could direct the data to EXCEL then I could resume with the data collection.I can create a program to write the data in EXCEL format in a file butthat is not my intention.There is no editing since the device is just an automated hardware.Thank you,Harry.

Resume In Excel Format

Hi,Use NETComm.ocx. Set the properties in the Load event, and open the port.