How to get the relevant information using "open dialogue box" in Excle

[prasath]

Hi,

In one my excel workbook i would like to add the below feature. Pl. suggest.

1. When the user click the command button
2. Excel should open the dialogue box where users can choose the input Excel file
3. Once they choose, it should get the information from that excel sheet to current workbook..

3a) lets say Sheet A - --- Sheet A of base workbook
3b) Sheet B --- Sheet B of base workbook

4. And close the user picked excel sheet..

Note : File name of "users input file" will not be constant...

Thanks in advance
Prasath RH

 

[prasath]

Hi,

Could anyone help me on this..

Thanks in advance

 

[prasath]

Hi,

Could anyone suggest me on my below request..

Thanks