Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    24

    Question Unanswered: How to get an array of subfolders of a specified folder??????

    Any idea how to do this in VBA?

    THX

  2. #2
    Join Date
    Feb 2003
    Posts
    24

    Thumbs up Re: How to get an array of subfolders of a specified folder??????

    Well I found the solution thx!!
    I have to say that the help in VBA is not really helpful!!!

    FAO anyone interested:

    Set fse = CreateObject("Scripting.FileSystemObject")
    Set fe = fse.GetFolder(<specified folder path>)
    For Each sfe In fe.SubFolders
    Debug.Print sfe.Name
    Next sfe

    Originally posted by thorgnole
    Any idea how to do this in VBA?

    THX

Posting Permissions

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