Hi there,

I need macro to copy first worksheet data from another workbook without opening it and paste to second sheet of active workbook.
Is it possible to add entering password (and save that password for future use) if chosen file is protected? It would be great if macro works when I click button shaped as open folder icon for showing file location/directory and choose file.

Thanks!
Nemat