Putting a search box

[Sylvia]

Hi..

I have to write one macro which will add a button allowing Copy function. This button should allow us to copy the whole contents of some another Excel file (containing single tab) into the currently open file.

For this I also need to add a search box which will allow me to search and select the file in windows after clicking on the above button and then proceed further..

Can anyone help me for this please?

Thanks,
Sylvia

[Dave Peterson]

You have a suggestion at your other post.

Sylvia wrote:
>
> Hi..
>
> I have to write one macro which will add a button allowing Copy
> function. This button should allow us to copy the whole contents of
> some another Excel file (containing single tab) into the currently open
> file.
>
> For this I also need to add a search box which will allow me to search
> and select the file in windows after clicking on the above button and
> then proceed further..
>
> Can anyone help me for this please?
>
> Thanks,
> Sylvia
>
> --
> Sylvia
> ------------------------------------------------------------------------
> Sylvia's Profile: http://www.excelforum.com/member.php...o&userid=30300
> View this thread: http://www.excelforum.com/showthread...hreadid=500585

--

Dave Peterson