+ Reply to Thread
Results 1 to 6 of 6

Getting file date from a excel file

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Geneva
    MS-Off Ver
    Excel 2007
    Posts
    59

    Getting file date from a excel file

    Hi there,

    Is it possible to get in a cell, through formula, the date of an Excel file itself?

    I need to get the 'last modified' date from a excel worksheet. In windows, view/details/date.

    Thanks a lot!!!

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Getting file date from a excel file

    The following macro will update cell A1 with the last file save time

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Geneva
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: Getting file date from a excel file

    Hi,

    It works for the worksheet I am working on, however I have modified the part "Thisworkbook" to the file I want to point it to and does not work. Additionally, I need to get several dates (meaning several files), so I am not sure whether this would work for all of them? THere is no way to do this with formula.

    Please note that I am interested in displaying other excel files (in the same folder) last modified date, and not time.

    Many thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Getting file date from a excel file

    FileLister.xlsm

    Lists all the excel files in a folder with their modified dates.

  5. #5
    Registered User
    Join Date
    11-12-2013
    Location
    Geneva
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: Getting file date from a excel file

    Hi Andy,

    Many thanks for the contribution! Although it's useful to list all the excel files, I really need to point to a few of them, not all. Also, I am looking for a solution without the commandbutton, it should get refreshed automatically.

    The first code you posted would be perfect if I could list several files and defining which ones.


    So, there is no way to do this with formula?

    MANY THANKS!

  6. #6
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Getting file date from a excel file

    Not by formula I don't think..
    The listing macro can be set to trigger automatically and be selective of specific files... The methods to do that depend entirely on the parameters

+ 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: 4
    Last Post: 10-23-2013, 12:54 AM
  2. Replies: 10
    Last Post: 06-07-2012, 09:17 AM
  3. Creating a .txt file extracting information from a Excel file saving as .resx file
    By AbdallahHajbed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2012, 09:00 AM
  4. Macro to save Excel file with date and time in the file name?
    By sonic_d_hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 02:00 PM
  5. Replies: 1
    Last Post: 12-07-2005, 01:55 PM

Tags for this Thread

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