Pulling ASCII data through com port

SSHARP323

New Member
Joined
Apr 10, 2015
Messages
1
I am trying to write an application to pull data from a device through a COM port (or virtual com port).

The company I work for has an external application that is used to pull the data and builds charts. We then paste the charts in an excel report and have no access to the actual data. I simply want to eliminate the external app and do everything inside excel, having access to the data.

Right now, my macro is pulling garbage. It looks like the operating system thinks the data is in some other format. But, if I open the external app, hit the import data button, I can then go back to excel and my macro works great. I do not even need to leave the external app running.

It seams that the external app is telling the operating system that the data is coming in ascii format.

I am using excel 2013 with windows 8.
I am using an RS232 to usb converter.
The tools that I am getting the data from is probably 10 to 15 years old.

I have not done any programming since the early 1990's, and things have changed a lot! I appreciate any input.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

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
Back
Top