hyperterminal, excel, and MSComm

[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

 

[Chip Pearson]

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)

 

[Andrew]

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)

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