Forum Discussion

icaredou's avatar
icaredou
Copper Contributor
Jan 17, 2023

Failed Excel macro after 1/10/2023 windows update

Below is a bold font step from a longer macro that was running fine multiple times fine through 1/09/2023. On 1/10/2023 a Windows update was installed.  “2023-01 Cumulative Update for https://suppor...
excel
Macros and VBA
Soproni99's avatar
Soproni99
Copper Contributor
Apr 09, 2023

icaredou 

I had a similar problem, but not exactly the same. 

 

Mine occurred only later in 2023, in early April, and I believe it must have been a security release made in late March or early April. I am using Windows 10.  In the case of my Excel VBAs, which were running smoothly for years, they stop with error 429 - "ActiveX component can't create object." 

 

The point at which the error is raised is when they try to create the WORD application object, or open a WORD any other sort of Office file.  All the files in question are on my personal One Drive, which I have designated as a Trusted Location.  No warning message about running VBAs is encountered when I open the .xlsm files.  I'm at a loss of how to get my valuable VBA programs running again.

 

Other Excel VBAs, which open only other Excel workbooks, or do not open anything, execute without problems.

 

I would be very grateful for any suggestions.