Hello:
Please refer to attached file.
I have xlsm file as shown in cell C3.
I need a VB code to get the Date and time of the last modification made on this file and put that in cell D4
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have xlsm file as shown in cell C3.
I need a VB code to get the Date and time of the last modification made on this file and put that in cell D4
Let me know if you have any questions.
Thanks.
Riz
FileDateTime is what you need, add the following UDF and then refer to it in D4
ie = Modified(C3)![]()
Please Login or Register to view this content.
Last edited by pjwhitfield; 01-11-2016 at 10:10 AM.
If someone has helped you then please add to their Reputation
Ignore - didn't notice the file name was in a cell...
If you mean the File Date/Time last saved, then
Add to a modula and use as a UDF![]()
Please Login or Register to view this content.
Hello:
Please refer to attached file.
Can you please check and see what i am doing here.
I am getting error.
Let me know if you have any questions.
Thanks.
Maybe:
![]()
Please Login or Register to view this content.
Hello Pj:
Thanks a lot,...it works
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks