Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Search in Sub folder (X97-->)

    Hi All

    This is an extension to a project I am undertaking ( <img src=/w3timages/censored.gif alt=censored border=0> user changed their mind again).

    I had created an Excel application that allowed the user to find a specific folder on a shared drive. This folder contained a series of excel workbooks that were copied and then collated into a main reporting/consolidation workbook which summarised the contents of the other sheets in the folder.

    Due to the complexity of the various worksheets that are produced by the user and the way they are reported it is necessary for them to be seperated into 2 subfolders. Now I have seen this <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> somewhere in the lounge but I can't find it ( or work it out) is to select a specific folder and let the code also find look inside a subfolder.
    Jerry

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search in Sub folder (X97-->)

    Maybe the thread containing <post#=319305>post 319305</post#> might be of use?

    Alan

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Search in Sub folder (X97-->)

    You can use Application.FileSearch to search for files in a folder and its subfolders. Type FileSearch into the Visual Basic Editor and press F1 to get online help.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Search in Sub folder (X97-->)

    Thanks Alan

    This should do the trick
    Jerry

Posting Permissions

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