Excel 2002 macros: will they work in Office 365?

[pcc]

Hi everyone. I have a very old laptop running Windows 10 and Excel 2002. It is very slow and I am thinking of upgrading. Many of the Excel workbooks that I have use userforms with various controls such as DateTime pickers, ProgressBars, Calendars as well as the usual more common controls such as CommandButtons, Labels etc. I am thinking of getting a more modern laptop and possibly subscribing to Office 365. I have a concern that, because my version of Excel is so old, my workbooks may not function correctly in Office 365. Does anyone have any insight into this? I do not cherish the thought of having to rework these workbooks if they do not work correctly (or at all!). Any advice appreciated. Thanks.

 

[RoryA]

DateTime picker and the Calendar control will be an issue, as they are not part of Office any more. Progress bar should be fine.

 

[MARK858]

FileSearch (if you use it) also got removed (Trying to remember if it was there in 2002), and also if you do decide to go down the 365 route make sure you install the 32bit version rather than the 64bit version or you will have to make more amendments to your code.

 

[pcc]

Thanks guys. I thought that might be the case. Filesearch was removed early 2000s, and I had to rework quite a few tools at the time. I despair that Microsoft remove functionality when they 'upgrade' their systems! Thanks once again.

 

[pcc]

With regard to DateTime picker and Calendar control, that's not a major problem, just an irritation...

 

[MARK858]

I thought that might be the case. Filesearch was removed early 2000s,

Application.FileSearch was removed in Excel 2007 (much later than your 2002), I just can't remember whether it came in before Excel 2002 (think it was)

 

[pcc]

Application.FileSearch was removed in Excel 2007 (much later than your 2002), I just can't remember whether it came in before Excel 2002 (think it was)

Yes you are correct. I was confused due to having Excel 2002 at home but various versions when at work. Thanks for the clarification.

 

[pcc]

FileSearch (if you use it) also got removed (Trying to remember if it was there in 2002), and also if you do decide to go down the 365 route make sure you install the 32bit version rather than the 64bit version or you will have to make more amendments to your code.

Picking up this old thread again. Please can you elaborate on your comments regarding 32bit/64bit versions of Excel? What are advantages/disadvantages of either version, and what sort of amendments would I need to make?
Regards

 

[MARK858]

What are advantages/disadvantages of either version

See the link below, unless you specifically need the extra power of the 64bit AFAIK it is still recommended to use the 32bit version

Choose between the 64-bit or 32-bit version of Office - Microsoft Support

Help to decide whether you should install the 32-bit Office version or the 64-bit Office version. Which version is right for you depends on how you plan to use Office. Find out about choosing between 32-bit Office and 64-bit Office.

support.microsoft.com

and what sort of amendments would I need to make?

See the link below for an example and some more useful info in more links in the post

Convert 32-bit code to 64-bit

I may be barking up the wrong tree, or at least making this sound easier than it probably is. I have a LARGE code that someone wrote almost 20 years ago that is going to stop working once our systems upgrade to 64-bit. How hard is it to convert from 32-bit VBA to 64-bit? When I was playing...

www.mrexcel.com

 

[pcc]

Thanks Mark858. That is extremely helpful. Looks like I will stick with the 32bit version, and the remark in the link about selecting the version before installation will save me a lot of bother. Thanks once again. Regards