Add-in Auto-Generation

[Guest]

We currently have some code in an Add-in which I would like to put into
source. Instead of putting the binary file into source, I would like to put
the class files as text into source for versioning. Now the issue I then
need to face is to create a process to import these class and module files
into an add-in.

Now I know I can probably create a vb app that can do this, but I am
wondering if excel has any current functionality that can dynamically build
an add-in from the command line for our build process. Or if there is
anything else out there that can do it for us. Any suggestions would be
appreciated.

Thanks in advance.

Reg,
Adam

 

[Rob Bovey]

We currently have some code in an Add-in which I would like to put into
source. Instead of putting the binary file into source, I would like to
put
the class files as text into source for versioning. Now the issue I then
need to face is to create a process to import these class and module files
into an add-in.

Now I know I can probably create a vb app that can do this, but I am
wondering if excel has any current functionality that can dynamically
build
an add-in from the command line for our build process. Or if there is
anything else out there that can do it for us. Any suggestions would be
appreciated.

Hi Adam,

Unfortunately, there's no way to do this automatically from Excel, so
you'll have to write it yourself. The code cleaner add-in available on my
web site has all of the logic required to export and import the VBComponents
in an add-in to/from text files. You're welcome to have a look at the code
and grab anything that's helpful.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm