Hello,
I have an app I am going to commercially distribute consisting of a VB6
front end with the back end of a VBA Excel 2003 app using automation and
also VBA Word. I was trying to see if it was possible and advisable to avoid
using digital certificates for the macros. One newsgroup respondent suggested
creating a com add-in in VB6 such as described in
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx.
I am not at all familiar with this method so I was wondering if anyone has
good experience and knowledge of such and the following:
1. Is this a feasible and efficient technique for avoiding having to get
digital certificates?
2. From skimming some of the articles, do I understand correctly that I can
create an exe with such not only enhancing performance but security of the
VBA code?
3. Can I put my entire-and fairly large Excel and Word VBA project into a
com add-in to accomplish the above?
4. Since this will be a widely distributed commercial app, will I be able to
automate the entire installation process with a good installer like Wise
Installer including changes to the registry?
I appreciate any and all help. Thanks and God bless,
Van