Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2010
    Location
    Rochester, NY
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Iím trying to build an Excel 2007 application that will get a list of Excel files in a directory and then do some processing on each file in turn. I canít figure out how to get a list of Excel files in the directory (it will be a dynamic list) so I can stuff an array to set up the processing Ė which I understand how to do. Any suggestions would be appreciated

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    It would need to be in VBA.

    You will probably find that using the Microsoft Scripting Runtime Library will have what you need in it.
    You'll need to set a library reference to it then use

    The FileSystemObject
    The Folders Object and the File Object.

    This will give you access to the files list anyway

    Some info available

    Here
    Andrew

  3. #3
    New Lounger
    Join Date
    Jan 2010
    Location
    Rochester, NY
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That worked, thanks.

Posting Permissions

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