Thanks again xld for your time,

I modified you code and got another runtime error. It listed the file name with runtime error 1004. It error stated to check the spelling and directory. I did but still had the same error. Also if I were trying to open the file from recently used files, ensure it has not been renamed or moved. The error came at this piece of the code:

Set mpWB1 = Workbooks.Open(mpFile1)