Friday 1 April 2016

Is there a compatability issue for VBA between Excel 2007 and Excel 2010 or newer?

I'm not a VBA expert and have only just started doing some VBA work at a new job. Some users have Office 2007 on Windows XP computers while others have Office 2010 or 2013 on Windows 7 computers. The workbooks have been fine until the end of March when the 2007 versions started doing rounding differently on some cells, if they even show numbers because sometimes they just show the pound sign. If a user opens the same workbook in Excel 2010 or Excel 2013 it's fine. Is this a problem that could be fixed or is it just incompatibility?

No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...