Serial-Excel communication

Pfluger

New Member
Joined
Mar 26, 2016
Messages
1
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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

rpaulson

Well-known Member
Joined
Oct 4, 2007
Messages
1,100
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,261
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top