Using a cell formula to give properties of a workbook
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 !!!!


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
  •  

 

 
DMCA.com