Serial-Excel communication

[Pfluger]

Hello everyone,

I have a project that is pushing analog values into my COM12 serial port every three seconds (3000ms). As of right now, I have a VBA so that I can manually copy the whole COM port data and paste it into the workbook, run the VBA and it takes the values and arranges them chronologically (by time) into cells (vertically). However, if possible, I would like to have these values be imported DIRECTLY into excel and be graphed at the same time so I can better view the data at a simple glance rather than having to transfer the data and graph it myself. It is important to note that my COM12 port is set at 9600baud, 8bits, None parity, 1 stop bit. I should also mention that nearly all of the analog values are three digits and I set up my code to place a single space (" ") between each value.

Just out of curiosity, is there a way to view an excel workbook remotely via app/internet/etc.?

Thanks!

Justin

 

[rpaulson]

Seems pretty straight forward. can you post a copy of about 5 records (15 Seconds) of the "imported Data", It should be pretty straight forward to parse out the string you need and write it to the next line in your spreadsheet.