How can I use VBA to check the last time another workbook was saved?

[tmyer2107]

Hello All,

I would like to know if it is possible to use VBA to get the timestamp that a different workbook that I do not have open was saved. I will explain what I am trying to do to clarify.

I am trying to create a spreadsheet that will pull data from two other spreadsheets. This spreadsheet will always be open on one computer. I want this spreadsheet to monitor the time that the other two workbooks were saved and then open those workbooks, pull in data, and then save itself. I can code that I just do not know how to get VBA to look at the time a different workbook was saved.

Thanks for the help!

[patel45]

try this code

Please Login or Register  to view this content.