Copy Data from Closed File to Existing File

Hi All,

I have created a macro for following functions.

1. Open the Workbook
2. Copy data (from C12 : D12 to Active cells)
3. Paste the data in already opend sheet. Paste from the next empty cells.

When am using the macro in Module, It is Working, however when i have assigned the Button, it is not working and showing at

Please Login or Register  to view this content.

Error message " Run Time Error '1004' Select method of Range Class Faild (Value of "1048576")

Complete Code is below:

Please Login or Register  to view this content.

Can someone help me for the above.

Can someone help me for the above case