Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Using a cell formula to give properties of a workbook

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

    Default

    Help !

    I need to put the last saved date of Workbook A into a cell in Workbook B.

    Any ideas ?

    I've been stuck for days !!!!!!

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

    Default

    You could add a simple macro to file
    B

    Sub test()
    Range("a1").Value = Format(FileDateTime("C:test.txt"), "mm/dd/yyyy h:mm AM/PM")
    End Sub

    Range("a1").Value - replace with the range in file B where you want the save date to go
    ("C:test.txt") - replace with address of file A

    Hope this helps

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Works like a dream !!!!

    Thanks for your help !!!!


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
  •