Version 1705 Undocumented VBA Language Changes
As you can see by many posts, we developers heavily utilize VBA. As versions change and items are removed, we have to adapt our macros accordingly. Most of the time major changes in the VBA language happen at major version upgrades (e.g. 2007 to 2010 to 2016).
Recently Version 1705 started to be pushed out to people. I have a simple bit of code that enables the events for all workbooks that open. Prior to Version 1705 it worked perfectly, but now it fails on the variable definition. (Dim x As New EventClassModule now gives an error - "Compile error: Automation error Catastrophic failure".)
EVERY online write-up of this operation has a similar structure. NO WHERE can you find the new way to accomplish this task.
Here is the full code:
[In a module]
Dim x As New EventClassModule
Set x.App = Application
[In a Class Module]
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
Half of the office has been pushed the update and are no longer functioning. The other half are still working on an older version.
All of the blogs say roll back to an older version. This will only temporarily solve the problem. We need better documentation of changes and ways to update our macros.
(Also an immediate solution for my issue would be greatly appreciated.)