Forum Discussion
Live import of RS232-USB data into Excel?
Hello! I currently have an old PC, running an old version of Windows. I have a new machine on Windows 10, with new Excel. I need to import data from an RS232 (serial) communicating device, that I hav...
JKPieterse Thanks, he peripheral is rather old, and I am using the prototcol they offer, RS232, which is working well with an old operating system. I am attempting to modernize the arrangement, by converting the rs232 to USB. It is once the data is introduced to the PC that I do not know how to import into EXCEL.
Hmm, sorry for confusing things. I was thinking about documentation of the RS232 to USB cable. It should normally come with a driver and have some form of documentation. Perhaps it adds a virtual COM port to your system. I know there is VBA code available that is able to receive data from COM ports using the RS232 interface. See: https://social.msdn.microsoft.com/Forums/office/en-US/0d05ec74-7f75-4fb3-ac28-30130c44cf3b/excel-2010-vba-send-and-receive-from-com1