Office 365 vs Office 2007 VBA - turn off 2007 updates?

Support for Office 2007 has expired. Which means you'll only get security updates as they release them. The update process is different for Outlook 2007 and Office 365. They are separated, and I don't think causing you issues in the way you've described.

What I think we should focus on is this:

"I've recently have had several Excel macro/VBA projects act wrong/differently."

What exactly do you mean by "wrong/differently"? Can you post some code? There are subtle differences in versions regarding forward compatibility. It's not a perfect application, but I'd wager 99.99% of code is 100% forward compatible. While we should rule that out, we should also look at the core code itself (please post).

Hi there,

Let's clarify a few things. First, you do not run Office 365 in the cloud. It is installed locally and runs locally. Your files may originate there, but even those open locally, then re-save back to the cloud. There is no such thing [atm] of running Excel in the cloud on a local machine. The closest you could get to that would be to have a browser open on your local machine which has Excel Online open on it, but you can't run VBA there.

Office 2007 will no longer update on your machine if you uninstalled it correctly. Any installed updates would have been removed with the application, unless it had to do with other applications, i.e. a Windows update, not an Office update.

When you say "Office 365", that doesn't tell us what version you are running. That tells us that you are paying for a subscription to Microsoft. There are many flavors of Office 365, ranging in prices. Those subscriptions come with software. For Excel, this is generally the latest version, although you can downgrade one version to 2013. It also installs differently than previous Office versions (known as MSI's), but the program is the same. The reason for the different install paths/properties is for updating. O365 can get updates pushed from the mothership (i.e. Microsoft) at a faster cadence - sometimes monthly even. I'm assuming you're running Excel 2016 for desktop.

VBA for Excel 2016 for desktop is indeed slightly different from VBA for Excel 2007 for desktop. But those differences are minute. First, Excel 2016 has VBA7, whereas Excel 2007 has VBA6. There is a 64-bit and 32-bit Excel 2016, but only a 32-bit Excel 2007. And the object model (OM) has had updates with the new features.

All this to say, it is rare to find code which worked in 2007 but does not work in 2016. The best thing you can do is post your code and tell us what the expected outcome is.

Zack,  thanks for the great reply.

I'm running Office 2016/365 version 16.0.7967.2161  I get frequent automatic updates.

I did un-install Office 2007, but later discovered my employeer's email exchange  server would not support Office 2016, so I had to re-install Outlook 2007.

I do frequently receive Office 2007 updates, perhaps it's related to the Outlook re-install.

The lates2007 update was done on 5/18/17 and is version 12.0.6612.1000

When I open Excel, I see Excel 2016, but I receive updates for both products.

I appreciate your response,  do you suppose the Excel versions might interact?

Dustin