Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.
Log the data on VB and then with that data create a file with the fields separated by commas, like this: **broken link removed**
name it *.csv and that's it you have a file that is openable with excel!
VBA is built into Excel. It should be able to respond to MSComm receive events. You could then take the data from the RS232 port and put it where you want. You should also be able to poll for events. Look it up in the documentation for VBA.