Results 1 to 7 of 7

Thread: List Folder location & Filenames into a Table and color

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-14-2014, 01:59 PM #1
    mrprofit
    mrprofit is offline
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0

    List Folder location & Filenames into a Table and color

    Attached is the WB i am working on, code modified from other forum,

    now i want to use the "Browse for Folder" to select the folder where the files is in eg. E:\My Docs\Global\ and list the folder location and filenames to table (column I:J), and color them according to every folder location.

    I would like the "Browse for Folder" windows to be able to select multiple files instead of just one file a time.


    Appreciate for any help, thank you
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Did You Know ::: Automatic Subtotals (& More) :: Data List Outline
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 09-23-2013, 03:13 PM
  2. Change Pivot Table Data Source Using A Drop Down List
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-05-2013, 09:33 AM
  3. List File name in folder to excel with images
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 01-15-2013, 11:37 AM
  4. List selected filenames in an Excel range of cells
    By TomyLee in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 06:24 PM
  5. List Of All Files In A Folder
    By Excel Fox in forum Excel Help
    Replies: 2
    Last Post: 10-27-2011, 09:10 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
  •  

Forum Rules