+ Reply to Thread
Results 1 to 6 of 6

VBA Macros to Brows Folder & List Entire Files

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Excel 2003, 2010 & 2013
    Posts
    884

    VBA Macros to Brows Folder & List Entire Files

    Hello Again,

    I have a VBA macro which I have adopted form web somewhere.

    It is working fine when I copy my workbook into that folder and run. It will list all the files.

    Can someone help me to change the below script so that I can brows folder then list the files.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,107

    Re: VBA Macros to Brows Folder & List Entire Files

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Excel 2003, 2010 & 2013
    Posts
    884

    Re: VBA Macros to Brows Folder & List Entire Files

    Hai Mumps,

    First of all I am thankful to you to respond to my request.

    I work as I wants.

    Can it be possible to get sub folder files also.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,107

    Re: VBA Macros to Brows Folder & List Entire Files

    Try:
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: VBA Macros to Brows Folder & List Entire Files


    Hi,

    FileSystemObject for sub folders is often the slowest way in particular when scanning an entire partition,
    slower than just using VBA Dir function but the faster is to use some Windows feature

  6. #6
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Excel 2003, 2010 & 2013
    Posts
    884

    Re: VBA Macros to Brows Folder & List Entire Files

    Hai Mumps,

    It works. Thanks for your help. Topic marked as solves and reputation added.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-11-2019, 04:37 AM
  2. [SOLVED] Trouble Updating a list of Files if a file no longer exists in the Folder/Sub Folder Dir.
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2019, 02:03 AM
  3. Copy Files from One Folder to Another Folder based on a List In Excel
    By civram1982 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2019, 06:34 AM
  4. [SOLVED] Macro to list and open .xlsm files in folder and sub-folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2019, 07:35 PM
  5. macros to list all files in folder THEN get info from files?
    By jonyorker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2015, 03:11 AM
  6. macros to allow me to choose what files i want in same folder?
    By taimysho0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 08:10 PM
  7. Replies: 1
    Last Post: 03-12-2013, 04:45 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1