none
Running Excel VBA code developed in Office 2010 under office 2013 RRS feed

  • Question

  • I have developed a large application successfully under Excel 2010 and I have a 30 day trial of office 2013. My applications will not run. However if I take a piece of code from the application and open a new spreadsheet under 2013 and place it in a sub and then run it ...works fine. So code that runs perfectly in an office 2010 environment will not run in the 2013 environment. I have changed the macro security settings to the most liberal and set the "trust VBA object model" option...still won't work. I know its not the code because I can insert it in a new sheet and run it. PLEASE HELP 
    Sunday, February 22, 2015 3:43 AM

All replies

  • Hello Roderick,

    It is not clear whether the code is working or not...+

    > However if I take a piece of code from the application and open a new spreadsheet under 2013 and place it in a sub and then run it ...works fine. So code that runs perfectly in an office 2010 environment will not run in the 2013 environment.

    I see the following statements:

    > and then run it ...works fine

    and then you wrote the opposite:

    > will not run in the 2013 environment

    Can you run the code under the debugger? Does it work in Office 2013?

    It looks like some of your event handlers are not fired. Am I right?

    Sunday, February 22, 2015 9:07 AM