Migrating from Office 2010 to Office 365

Bit of an open question ...

What do your macros do? If they refer to other applications, like Word and Outlook, or other objects, do you use Early or Late Binding?

I don’t know because I don’t understand what Early or Late
Binding is or how I would know which I am using.

If you control other applications, you would use their Object Model ... so, Word, PowerPoint, Outlook, or maybe Scripting. If you refer explicitly to the Object Model, you would have to include a reference to it ... and that's called Early Binding. If you don't explicitly refer to the Object Model, that's Late Binding. Doesn't sound as though it's applicable here.

See: https://peltiertech.com/Excel/EarlyLateBinding.html

Have a look here: https://answers.microsoft.com/en-us/...3-bd72b3557573

and here: https://www.excelforum.com/excel-pro...10-2013-a.html

and various other links where differences are discussed: https://www.google.com/search?client...0+to+Excel+365

Are you planning on changing from 32-bit to 64-bit in the process? If so, there may be other changes in functionality.

Difficult to give any guarantees but you shouldn't have any issues with formulae and Conditional Formatting in that you are moving from an older version to a newer version.

Similarly, if you currently have 32 bit Excel, I’d suggest you stick with it or you could experience issues with incompatibility. But, other than that, I suspect your code would transition across ok.

Seems like one of the problems discussed in a link provided by Ali was the processing speed of the computer. That is, the increased speed of the new computer introduced timing problems. Assume this will not be a problem for you?

Can you upload some typical examples of your workbooks for them to be tested?


Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You're welcome. Thanks for the rep.


See this link: https://support.office.com/en-gb/art...7-b78c513788bf

Playing devil's advocate here, but ...

This enquiry isn’t actually for myself it is for someone that I “try” to help.

Do we need to know this? Having an incompetent 'friend' who happens to be female (funny stereotype, that) doesn't add anything to the thread and the advice offered, does it?

She will be using same computer that has been running her applications without any problem (except “Human Error”)

And even if it does, do we need to know the extent of her incompetence? Poor lady, having her dirty washing aired on a public forum!

I may suggest to her to subscribe to 365 for a couple of months ...

I'd agree with this, possibly as a permanent move. I moved to the subscription model about three years ago - no regrets whatsoever, and with multiple family members included, it's much, much better value for us than the standalone version, plus it's never out-of-date.

Interesting that posts #1, #3, and #5 all read as though it is you that is thinking of migration to Office 365 ... your formulae, your CF, your macros.