Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Another Files search Question....

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    whilst file search is performing a search in a particular folder, is there a way to omit a sub folder from that search?
    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    I take it you're using the code I gave you earlier? If so, then you can either choose to have all subfolders searched or no subfolders searched - you can't omit some folders but include others. To omit all subfolders do something like this:-

    .SearchSubfolders=False

    If you want something else then please be a tad more specific i.e. which folders do you want to include/exclude?


    Regards,
    D

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The only thing now is that the file names and locations that are the result of the search are logged in A1 downwards. Is there a way to stop this record being made and just open the appropriate files? (So that the button can be used over without having to delete the data? if this makes any sense)

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just take out the line that says

    Cells(lngLoop,1) blah blah

    D

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, instead of not listing the file names found, is it possible to choose where they are displayed? and then clear them once they have been used?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •