create a button to seach documents contains "x" in a certain directory

07-27-2010, 01:19 PM

gogoaaron

Newcomer

Join Date: Jul 2010

Posts: 1

create a button to seach documents contains "x" in a certain directory

Hi, anyone can help me to write a code for
creating a button in Excel.
By clicking the button to start search files in certain directory?
and also files' name should contain the characters in activecell.
in other words, the contents in ACtivecell is the searching criteria for file name.
I start with
code:
Sub Button1_Click()

End sub

---------------------------------------------
and I have no clues any more
Thanks for helping me out!!!!!!!!!!

07-27-2010, 02:48 PM

Bob Phillips Bob Phillips is offline

Contributor

Join Date: Jul 2009

Posts: 506

Code:

Dim Filename As String
Dim Filepath As String

    Filepath = "C:\Test\"
    Filename = Dir(Filepath & "*" & ActiveCell.Value & "*")
    Do While Filename <> ""
    
        Workbooks.Open Filepath & Filename
        'do something with activeworkbook
        Filename = Dir
    Loop

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules