Issues with VBA after upgrading to Version 2311 (Build 17029.20108)

Anonymous
2023-12-18T11:06:31+00:00

Hi, after updating to Version 2311 (Build 17029.20108), we face seriously many issues with our Excel Macro solutions. Something we have never seen before (or at least not for a long period of time). Even things like standard commands like thisworkbook fail. We had to change to 'Monthly Enterprise Channel 2310', which fixed the issue.

Also, it happens on different computers, with different workbooks, so it's not a question about reinstall Excel or something like that.

Btw. We have been working with Macros as our Core business for more than 8 years, and have millions of lines of code. So we normally know what we do.

Is there other people in here which get the same kind of errors with VBA using this version?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-01-10T18:50:07+00:00

All our issue was fixed by rolling back from Version 2311 (Build 17029.20108) to Version 2310 (Build 16924.20180).

We had all kind of weird issue with this Version 2311 (Build 17029.20108).

Was this answer helpful?

6 people found this answer helpful.
0 comments

157 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2023-12-19T20:37:42+00:00

    Actually, I don’t know. I don’t use this part, as we just coding everything in the build in editor.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-12-19T20:35:35+00:00

    We attempted to use Office Scripts as a substitute for VBA, but in our specific case and the way we build solutions, it fell significantly short of VBA for several reasons.

    Regarding the number of solutions I've developed in VBA for our company, it varies depending on the specific task and solution. Could you specify whether you work on Windows or MAC computers?

    The suitability of VBA versus other tools like PowerApps and Power Automate depends on the particular task at hand. There are certainly tasks where PowerApps and Power Automate can be effective. Do you have any specific examples in mind?

    Also it’s important to keep in mind, if the solution is going to be shared across a team, or just to be used as individuals.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-12-18T19:55:06+00:00

    Hi Alexander,

    Thank you for your response.

    I understand the blocking of macros by default per this article: Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Learn

    What I don't understand are statements by people telling me that macros are going away.

    Let's talk about VBA...

    I have found only a few statement that suggest that VBA is going away.

    from: https://www.quora.com/Does-VBA-programming-have-any-future "VBA's future may be uncertain as Microsoft has been pushing for the use of more modern programming languages such as C# and Python for automation tasks...."

    I would like to know if VBA is going away in the future. We don't have any money in our company to purchase new tools nor money to rewrite our current VBA code we use behind Excel via macros. We also run macros via the .MAC extension. We are thinking about leveraging Power Apps and Power Query instead of purchasing VB.net or the like. Do you think that Power Apps and Power Query would be viable solutions for us to replace the VBA being used via macro in Excel files?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-12-18T16:40:17+00:00

    Hi Will Stephens2,

    I have read extensively on this subject. However, I haven't found any sources stating that Microsoft plans to discontinue VBA. It seems unlikely to happen anytime soon, given the widespread use of VBA in Excel workbooks by numerous organizations worldwide.

    From what I understand, Microsoft is merely shifting its focus to other technologies and is not actively updating VBA for the time being. This aligns with general best practices and available information about Microsoft's position on VBA.

    Regarding the blocking of macros, we mitigate this by signing all our VBA solutions with a certificate. This certificate is then installed on the PCs that use our Excel macro files, allowing users to operate them safely. This is a sound security practice recommended for enhancing macro security in organizational environments.

    Was this answer helpful?

    0 comments