Excel - Programmatically insert VBA code in an existing spreadsheet and execute in spreadsheet RRS feed

  • Question

  • We download spreadsheets from a certain site daily. We need to add command buttons to these newly downloaded spreadsheets to control display usage of them.

    I need to add existing VBA code programmatically to these downloaded spreadsheets to insert command buttons in them and execute the code when clicked.

    How can this be done?

    • Edited by Elie B Monday, August 13, 2012 9:49 PM
    • Moved by Hila Shemer Wednesday, August 15, 2012 4:25 PM This question is not related to apps for Office. (From:Developing Apps for Office)
    Monday, August 13, 2012 9:48 PM

All replies

  • Hi Elie

    Your question was moved because it was off-topic in a forum dedicated to new technology in the beta for Office 15. I suspect it may need to be moved again in order to get optimum support, but we need a bit more information, first :-)

    Which version of Excel is involved?

    By "command buttons" do you mean buttons in the Ribbon, or something else?

    Cindy Meister, VSTO/Word MVP

    Sunday, August 19, 2012 3:59 PM