Run Excel 2007 macros with Excel 2013


I am installing a new computer for a user who is scared of upgrading to Office 2013

His Excel 2007 macros (not VBA) function properly with his present (french) version of Excel 2010

Apparently he ran a few tests in the past and discovered the following issues:

- the date of origin is apparently different between version 2007/2010 and 2013 meaning that date calculations won't produce the same results

- the space character isn't interpreted in the same manner (ignored in some cases)

- in France the decimal and thousands separators are the inverse compared to the English system: our decimal separator is the comma, and the thousands is a period.
When a decimal comma is preceded by (to the right of) a single zero, the macro correctly interprets the number;
when, however, the number preceding the decimal comma is greater than zero, then the macro considers the comma as a thousands separator. He also stated that the regional settings had no bearing on this issue.

There are may be other issues, but these are the ones he detailed for me.

Any ideas ?
Yann ShukorOwnerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Date calculations have not altered between versions, nor have spaces, or the way regional settings are used. I don't think your user, with all due respect, really knows what he is doing. Can you ask him for specific examples of what doesn't work?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Yann ShukorOwnerAuthor Commented:
thanks for the confirmation Rory
that was my sentiment, but not being a macro expert, I gave him the benefit of the doubt
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.