Best solution to develop add-ins

[brazilnut]

I have been building an application in VBA. It has now grown to over 100 pages of code and forms. As the number of features grows, the application get's slower. I am considering converting my code to a compiled format, ie VB .NET. I am looking for options. Is there a better solution?

thank you

 

[XL-Dennis]

Hi,

There are some options available:

1. Consider to split the add-in into several parts and load them on demand via a menu or toolbar.

2. Create a COM add-in in VB Classic as it will not require that the NET Framework is installed on the target machines.

3. Create the add-in in VB.NET and make sure You pack the redistributable version of NET Framework into the setup-packaged.