[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!

    Files

    • 0411_Dr.xlsx

      (14.17 kB, downloaded 55 times, last: )
    • 0110_Dr.xlsx

      (13.56 kB, downloaded 61 times, last: )
  • 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.

    Rory
    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.