+ Reply to Thread
Results 1 to 2 of 2

List the Name of Latest Modified File by File Type

  1. #1
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    List the Name of Latest Modified File by File Type

    I found the below code module which lists the name of the latest modified file in a directory.

    I want to get the latest modified file for a particular file type. For e.g., file types can be .csv, .pdf, .doc, .ppt, etc.
    How can the below code be modified to do that ? Can someone help ?

    Please Login or Register  to view this content.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: List the Name of Latest Modified File by File Type

    You need a modification like

    Please Login or Register  to view this content.

+ 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. Update cell based on Modified date from another file type.
    By Mrcoop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2014, 10:59 AM
  2. Replies: 2
    Last Post: 02-27-2014, 02:23 AM
  3. Replies: 0
    Last Post: 01-21-2014, 10:52 AM
  4. [SOLVED] Automatically open the latest date modified excel file in a folder
    By arleutwyler in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2014, 01:35 PM
  5. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  6. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  7. [SOLVED] How do I find a list of dates a file has been modified?
    By cpateach in forum Excel General
    Replies: 0
    Last Post: 05-30-2006, 08:20 PM

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