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.
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.
