ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Putting a search box (https://www.excelbanter.com/excel-programming/350204-putting-search-box.html)

Sylvia[_13_]

Putting a search box
 

Hi..

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

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

Can anyone help me for this please?

Thanks,
Sylvi

--
Sylvi
-----------------------------------------------------------------------
Sylvia's Profile: http://www.excelforum.com/member.php...fo&userid=3030
View this thread: http://www.excelforum.com/showthread.php?threadid=50058


Dave Peterson

Putting a search box
 
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


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com