Open specific folder, select file to open and copy then paste

Originally Posted by Norie

Kranky

Do you want the user to be able to choose the cells, perhaps even the worksheet, to copy from the workbook that's been opened?

.

Yep - just thought it would be useful to be able to do this. I dont have a specific use for it. Pretty silly really to do it through a macro when the file can just be opened and the cells selected etc