Selecting file

[fi.or.jp.de]

Hi,

I have folder contains 10 to 15 excel file.

I want a macro that display open dialog and if user selects 3 files or
2 files,
then sheet1 of selected files data to copied and pasted in another
workbook.

Thanks in advance

 

[Dave Peterson]

Check your earlier post.

Hi,

I have folder contains 10 to 15 excel file.

I want a macro that display open dialog and if user selects 3 files or
2 files,
then sheet1 of selected files data to copied and pasted in another
workbook.

Thanks in advance