[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

  • Some of that code looks like code that I supplied for you. There is nothing in the code that uses ActiveX.

    Attach the workbook containing the code.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!