ActiveX distribution

[John Rischmiller]

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?

 

[John Rischmiller]

Thanks, Bill

 

[John Rischmiller]

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?