Insert Macro into Excel Workbook using C# code

[Gary Nguyen]

Let's say I have thousand of existing excel workbooks and I want to insert
a macro funtion into all of them. Is there a way to automate this.
I'm looking for a way to insert the VB macro function (such as
Workbook_BeforeClose function) into ThisWorkBook using C# code.
Does anyone know what Microsoft provides us or references to proceed this?
Thanks

 

[Ken]

I have not done much code to modify VBA, but, when I have, I start
with Chip's site:

http://www.cpearson.com/Excel/VBE.aspx

Good luck.

Ken

 

[Gary Nguyen]

Thanks but I'm looking for a way in c# that can insert macro into workbook.