Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Didnīt Work! Put in cell Last Modified spreadsheet value

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi!!
    Iīm still having problems with this...

    I have 400 spreadsheets and they all were saved in some day (from Jan 1 till today)
    The problem is that the date is set to the formula TODAY()... Now I fixed this...
    But I would like those 400 spreadsheets do display in cell A1 for example the date it was modified for the last time... That column that appears in Windows Explorer..
    Is there a way to obtain those values automatically?? Without looking and typing...

    THANKS A LOT!!!

  2. #2
    MrExcel MVP
    Colo's Avatar
    Join Date
    Mar 2002
    Location
    Kobe, Japan
    Posts
    1,456
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default

    Hi FlavioRJ,

    On 2002-05-09 17:49, FlavioRJ wrote:
    Hi!!
    Iīm still having problems with this...

    I have 400 spreadsheets and they all were saved in some day (from Jan 1 till today)
    The problem is that the date is set to the formula TODAY()... Now I fixed this...
    But I would like those 400 spreadsheets do display in cell A1 for example the date it was modified for the last time... That column that appears in Windows Explorer..
    Is there a way to obtain those values automatically?? Without looking and typing...

    THANKS A LOT!!!
    So, please try this way.


    'Please put this code into Thisworkbook Module
    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Sh.[A1].Value = Now
    End Sub


    Hope this helps + pen pineapple apple pen!

    Masaru Kaji aka Colo - cellmasters.net

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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