hyperterminal, excel, and MSComm

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello,
I am trying to set up a data acquisition system which is already
functioning in hyperterminal. I would like to be able to have the
data dump directly to excel. I have done enough internet searching to
figure out I need to put a communications module onto a user form. So
I have added the additional controls in the form of MSComm. But when
I try to put it onto a form, I get an error "The control could not be
created because it is not properly licensed." I own the computer and
the software, so how do I license something I already own?

So, question 1. How do I deal with the license thing?
Question 2. Does anyone have an example code of pulling data from
hyperterminal into Excel. FYI - I am aware that I can dump data into
a csv file and then import to Excel. This isn't what I want to do. I
want to be able to plot and calculate the incoming data in real time.
So I need the data to be dumped into excel, as if hyperterminal were
simply routing the data. Any examples would be great.

thanks,
Andy
 
Some controls are distributed to end users with a run-time only
license. This means that they can be called from programs that were
created with a design-time license, but cannot be used in other
development. I suspect that you got the MSComm control as part of
another program. This would mean that you have a run-time license, not
a design-time license, for the component. You get a design-time
license when you have a program like Visual Studio installed on the
machine.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Some controls are distributed to end users with a run-time only
license. This means that they can be called from programs that were
created with a design-time license, but cannot be used in other
development. I suspect that you got the MSComm control as part of
another program. This would mean that you have a run-time license, not
a design-time license, for the component.  You get a design-time
license when you have a program like Visual Studio installed on the
machine.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
    Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)
Click to expand...

I have Visual Studio on my machine. Now, I might have gotten this
MSComm from a Siemens PLC software which used an OPC server to link to
Excel (presumably through Hyperlink). So, does anyone know how to
make this work? Do I have to buy a run-time license (which I
apparently don't have)? If so, where does some buy such an item?

thanks
 
Back
Top