VB.Net Add-in for Excel - can I change Excel VBA?

[sedrisco]

I have a VB.Net Add-in for Excel that I'm updating. It works with a previously created Excel Template. I am updating the Add-in and the template, and would like to programmatically make my template changes in existing workbooks created from the template. I've found that I need to change some of the VBA in the template, and I'm wondering if there is a way to change the VBA programmatically from the Add-In code? I know I can just change the VBA in the template and users will use the new template, but what about the existing workbooks? Is there a good way to update the VBA for those without going into each existing workbook?

Any suggestions would be helpful! Thanks!

 

[NoseBooger]

See Microsoft Knowledge Base Article - 303871
HOW TO: Create an Excel Macro by Using Automation from Visual Basic .NET

http://support.microsoft.com/default.aspx?scid=kb;EN-US;303871

You access the code using the VBProject.VBComponents properties of a workbook.