Excel 2013 VBA Compatible with Excel 2010 RRS feed

  • Question

  • Hello,

    I am new at working with VBA and have a question regarding an excel sheet with a VBA macro inserted.

    The sheet was created in Excel 2013 by another user, and my laptop runs Excel 2010.  I get script errors when I run it, however on Excel 2013 it works fine.

    My question is: Is there a way to make Excel 2010 work with Excel 2013 VBA scripts? Perhaps importing the library from Excel 2013 VBA to E-2010?  Or perhaps a way to save a VBA script in E-2013 to be backwards compatible with E-2010?

    Thank you all for your support.

    Sunday, March 22, 2015 8:43 AM

All replies

  • Open the workbook.

    Select Tools > References...

    The references that are in use have their check box ticked. They are all at the top of the list. Do any of those start with MISSING?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, March 22, 2015 10:06 AM