Pulling ASCII data through com port


New Member
Apr 10, 2015
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.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...