none
activate XLAM file macro from VSTO add-in RRS feed

  • Question

  • Hi

    I have a xlam add-in developped in VBE and I would like to launch the XLAM file macros from a custom UI developped in VSTO. How to make the link ?

    I know this is possible with XLSM file but can't find any answer for XLAM.

    Thanks

    • Moved by Teodora Sharkova Monday, August 8, 2016 11:46 AM moved from French forum
    Monday, August 8, 2016 11:28 AM

Answers

  • Hi,

    >>I have a xlam add-in developped in VBE and I would like to launch the XLAM file macros from a custom UI developped in VSTO. How to make the link ?

    Use _Application.Run method

    E.g.

    I am calling a module in the Book1.xlam from the custom ribbon created by VSTO

            private void button1_Click(object sender, RibbonControlEventArgs e)

            {

                Globals.ThisAddIn.Application.Run("Book1.xlam!test");

            }

    • Marked as answer by GDA2016 Thursday, August 11, 2016 6:48 AM
    Tuesday, August 9, 2016 7:00 AM
    Moderator