The files listed below need to be in the following directory in order to package your component:
<root project directory>/distrib
FILES:
1. component_name.bas (generated from Excel Builder)
2. component_name.xla (generated from Excel)
3. component_name_version.dll (generated from Excel Builder)
As long as these three files are in the distrib/ directory, you should be able to package your component by selecting 'package component' under the component menu of MLXTOOL.
Note that component_name.bas (generated from Excel Builder) is not directly needed for distribution. The .bas file is imported into the Excel addin (.xla). If you do not distribute the Add-in, but only the component, then the .bas file is needed too.
If the end-user of your component already has the following files it is not necessary to package these files.
mglinstaller.exe
mwcomutil.dll
mwregsvr.exe
All the end-user needs is the component (*.dll) and the Excel Add-in (*.xla). However before the user can use the add-in he must still register his component with mwregsvr.exe.
The packager however will not allow you to package without these files. You must package the files manually, perhaps into a zip file. In doing so, you reduce the size of the file you distribute to your end-users.
Best Answer