Ok hold on. I have already provided you the code to do the copy paste. What is currently not working is the workbooks.open part. Can you give me the path from where you open the file ? Also, give me the name of the file.