[ERROR] Error 429 ActiveX component can’t create object

  • Hi.

    For the past hour I have been trouble shooting my VBA code to resolve the following error when trying to merge excel files with the code, however this error pops up every time on the 2nd phase of the code where it copies all sheets' data onto a single sheet named "Combined", can anyone assist to troubleshoot my code?

    I have attached test files just in case it is needed. Thanks!

  • Apologies, this is the full code if needed.

  • Which line causes the error? I can't see any code there that tries to create any objects.

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why