Measurement Studio for VB6

cancel
Showing results for 
Search instead for 
Did you mean: 

how do I distribute an Excel VBA app with cwds.ocx

I am trying to install an Excel VBA app in a lab NT workstation. This is not the development computer. I am writing an LV app to write data to DataSocket. I will read it
with the VBA app and store it into a range of cells in the Excel spreadsheet.
When I install Datasocket (v4.0) on the workstation, I get the demo version of the OCX.
The licensed version of the OCX is not in the \cw\redist directory or in the MeasurementStudio\VB\redist directory.
How do I install the correct version of the cwds.ocx and related files onto the destination machine (preferrably the proper way, but any way will do!)??
Thanks
Dave Karon
Concepts NREC
Wilder, VT
mailto: dkaron@conceptsnrec.com
0 Kudos
Message 1 of 3
(4,495 Views)
There is not a "licensed" version of the control. The control looks for the licensing information in the application or in the registry. Visual Basic automatically includes the licensing information for the controls you are using in the EXE or OCX files you create. It sounds like VBA in Excel is not automatically including this information. You should consult MSDN to find out how to distribute licensing information in VBA. In VB, they use the package and deployment wizard which is discussed here (http://support.microsoft.com/support/vbasic/gettingstarted/pdw.asp). I'm not sure how it is done with VBA and Excel.

Best Regards,

Chris Matthews
Measurement Studio Support Manager
0 Kudos
Message 2 of 3
(4,493 Views)
You probably need Office Developer - Pakage and deployment wizard menu!

"Dave Karon" wrote in message
news:506500000008000000E1190000-986092468000@quiq.com...
> I am trying to install an Excel VBA app in a lab NT workstation. This
> is not the development computer. I am writing an LV app to write data
> to DataSocket. I will read it
> with the VBA app and store it into a range of cells in the Excel
> spreadsheet.
> When I install Datasocket (v4.0) on the workstation, I get the demo
> version of the OCX.
> The licensed version of the OCX is not in the \cw\redist directory
> or in the MeasurementStudio\VB\redist directory.
> How do I install the correct version of the cwds.ocx and related files
> onto the destination machine (preferrably the pro
per way, but any way
> will do!)??
> Thanks
> Dave Karon
> Concepts NREC
> Wilder, VT
> mailto: dkaron@conceptsnrec.com
0 Kudos
Message 3 of 3
(4,494 Views)