Browse to Select File And Import Specific Data - VBA

[getlucky]

Hi

I need a macro to open the browse window and enable me to choose the file i want to open. Then copy the specific worksheet(entire) from recently opened excel spreadsheet to the macro file. I want this to be done for 3 files so I would need a loop function as well.

Please help me as I am unable to set up the correct VBA code in this respect.

Thanks in advance.

[Admin]

Hi

Welcome to board.

Try these links first:

http://www.excelfox.com/forum/f2/macro-to-browse-select-file-and-import-specific-data-1190/

http://www.excelfox.com/forum/f2/macro-to-browse-select-file-and-import-specific-data-859/