I've completed an Excel workbook for a client. The userforms contains an
ActiveX control from my VB6 environment (the DateTimePicker). A couple of
questions:

1. Is it legal to redistribute the DTP for an Excel workbook? It clearly is
if it's a VB application, but what about its use in a VBA environment?

2. Can anyone suggest an appropriate packaging method? I had thought of
using VB6's Package and Deployment wizard with a dummy VB6 program using the
appropriate OCX, and then deleting the VB6 dummy prog from the setup
process. Any other less kludgy ideas?

--
Regards - John Rischmiller.

Thanks, Bill

--
Regards - John Rischmiller.

"Bill Lunney" wrote in message
...
1 Not 100% sure of the legalities of this. AFAIK there is no issue.
There
are no royalties etc. due on the use of this control.

2 If you're just talking about one OCX I wouldn't bother with the overhead
of something like Wise or InstallShield (which are options). You can just
copy & register the control (DTP control) with a batch file.

copy abc.OCX %windir%\system32
REGSVR32 \%windir%\system32\abc.OCX



--
Regards,


Bill Lunney
www.billlunney.com

Despite Bill's very good approach, how do others distribute Excel based
solutions? I'm looking, in addition to implementing ActiveX controls either
standard or my own, for the basis for integrating into the customers Windows
environment. E.g. putting the xls/xla into Program Files, adding to start
menus etc. I appreciate that I can roll a script for one of the many
installers, but is there any kind of equivalent to the VB6 P&DW?

--
Regards - John Rischmiller.

"Bill Lunney" wrote in message
...
1 Not 100% sure of the legalities of this. AFAIK there is no issue.
There
are no royalties etc. due on the use of this control.

2 If you're just talking about one OCX I wouldn't bother with the overhead
of something like Wise or InstallShield (which are options). You can just
copy & register the control (DTP control) with a batch file.

copy abc.OCX %windir%\system32
REGSVR32 \%windir%\system32\abc.OCX



--
Regards,


Bill Lunney
www.billlunney.com

"John Rischmiller" wrote in message
...
I've completed an Excel workbook for a client. The userforms contains an
ActiveX control from my VB6 environment (the DateTimePicker). A couple
of
questions:

1. Is it legal to redistribute the DTP for an Excel workbook? It clearly
is
if it's a VB application, but what about its use in a VBA environment?

2. Can anyone suggest an appropriate packaging method? I had thought of
using VB6's Package and Deployment wizard with a dummy VB6 program using
the
appropriate OCX, and then deleting the VB6 dummy prog from the setup
process. Any other less kludgy ideas?

--
Regards - John Rischmiller.