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