Using a cell formula to give properties of a workbook

[EvansL]

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 !!!!!!

 

[jfuoti]

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

 

[EvansL]

Works like a dream !!!!

Thanks for your help !!!!