I browsed for Acrobat.tlb, but when the macro ran, it kept displaying that it cannot insert page from this line: MsgBox "Cannot insert pages of" & vbLf & p & a(i), vbExclamation, "Canceled"
Hi and welcome to VBAX!
You can't insert new page after the PDF document with password protection has been inserted.
Have a look on protection property of the last document inserted into the resulting file MergedFile.pdf