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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

rpaulson

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

Forum statistics

Threads
1,136,277
Messages
5,674,799
Members
419,526
Latest member
ranjit446

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top