Insert Macro into Excel Workbook using C# code
 

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

Insert Macro into Excel Workbook using C# code
 

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



On Sep 16, 1:31*pm, Gary Nguyen
wrote:
* 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

Insert Macro into Excel Workbook using C# code
 

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

"Ken" wrote:

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



On Sep 16, 1:31 pm, Gary Nguyen
wrote:
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