File dialog box to open a excel file then copy data close file

Please Login or Register  to view this content.

Then substitute the file name you want for 'ThisWorkbook'

Please Login or Register  to view this content.

Just make sure the workbook is open when you do it that way. Otherwise you might need to use both the path and file name to open the workbook in the same fashion as the one using the wb variable. You need to be clear about what you are looking for in the original post, to avoid these secondary conversations.

From which sheet do you want to copy the data?
And which sheet do you want to paste into?
The way you have it now will just point to whichever sheet was the active sheet when saved previously and the sheet that happens to be active in the workbook you want to paste into.

Dave's Excel has the below code.
Should be easy to change to your requirements.

Please Login or Register  to view this content.