How to export an Excel file to a serial port

S

smiserA

I need to create a “Set-up Screen†in Excel wherein several variables are
entered into a desktop PC and exported to a remote microcontroller via the
serial port.

Also needed is the ability to import data from the microcontroller via the
serial port into Excel for processing and displaying.

The microcontroller has RS232 I/O capability. The desktop has XP operating
system and Excel is part of MS Office 2003.

Can you tell me how to establish two-way communications via the serial port
so I can generate and receive data in Excel?

Thanks,


William arnold
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Reading Serial data from a port into a database. 1
Send data to serial port 3
Excel & Comm port 1
macro to add an auto serial number column 3
getting SPC data into excel 2
Serial communications 2
advise on how to import data into excel sheet 1

Top