+ Reply to Thread
Results 1 to 4 of 4

Add file names to combobox list from folder by date

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Add file names to combobox list from folder by date

    Hello,

    I am adding a list of file names to a combobox list and want to filter this by adding only the filenames that have been modified today. I have used the FileDateTime(Fil) but it leaves the combobox empty. I am using the code below thanks to a post from RoyUK, but cannot figure out how to add only the files modified today.

    Any help would be greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: Add file names to combobox list from folder by date

    Hi Nu2Java,

    You had the right function, just needed the two dates being compared in the same format. Try this for a dd/mm/yyyy comparison:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Add file names to combobox list from folder by date

    Hi Robert,

    Thanks very much.... this is JUST what I needed.

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: Add file names to combobox list from folder by date

    You're welcome. I'm glad we were able to provide you with an acceptable solution

+ 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. List file names in folder
    By Temporary-Failure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2013, 02:43 PM
  2. [SOLVED] VBA - folder/file names to spreadsheet list
    By Apelcius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2012, 12:03 PM
  3. List of file names & details in a folder
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2012, 04:02 AM
  4. Reorder combobox filled from folder file names
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2010, 05:10 PM
  5. List File Names From Folder
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2009, 03:51 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