How to Retrieve Macro Name Using VSTO in C#

{

if (pj.Protection == vbext_ProjectProtection.vbext_pp_none)

{

foreach (VBComponent vbcomp in pj.VBComponents)

{

if (vbcomp.CodeModule.CountOfLines > 0)

{

for (int i = 1; i < vbcomp.CodeModule.CountOfLines - 1; i++)

{

newMacro = vbcomp.CodeModule.get_ProcOfLine(i, out prockind);

string str = vbcomp.Name;

if (curMacro != newMacro)

{

curMacro = newMacro;

macroList.Add(str + "." + curMacro);

}

}

}

}

}

}

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString());

}

return macroList;

}

After creating a method, fill in the drop down as shown in the following code. Display the macro name in this drop down.

public MacroList()

{

InitializeComponent();
cmbMacroList.DataSource = GetMacroList();

}

4. Create Excel workbook

Create an Excel workbook with two macros as in the following:

1. Start Excel. A new blank workbook is created.
2. Press ALT+F11 to start the Visual Basic Editor.
3. In Project Explorer, double-click "ThisWorkbook" to start the code editor.
4. Paste the following code for two simple macros in the code editor:
   
   Option Explicit
   
   Sub Macro_A()
   MsgBox "This is Macro A"
   End Sub
   
   Sub Macro_B()
   MsgBox "This is Macro B"
   End Sub
   
5. Close the Visual Basic Editor, and return to the spreadsheet view.
6. In Excel 2003 and in earlier versions of Excel, save the workbook as C:\Abc.xls. In Excel 2007, save the workbook as a macro-enabled workbook named C:\Abc.xlsm.
7. Close the workbook and quit Excel.

5. Output of the sample

1. Build and run the application.
2. There are two way to test this sample. When you run this sample, by default Excel is opened. You can add the macro and see the macro name in the drop down. The second option is, since you have already saved the macro file on your machine, click on "Macro add-ins" and see the macro name in the drop-down.