I have a Dot Net application which launches MS Access. I am able to write the values into excel also.
But I need to add Macro for the excel to calculate, save etc.

Normally the VBA editor opens up in Excel when Alt-F11 is pressed.
There are a few Subroutines inside the VBA editor as follows:
Private Sub Worksheet_Calculate()
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub

Now from my dot net code I want to write into these methods. How can I do that. May be I need to create a separate function also inside the VBA editor.

Thanks in advance.