ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using the Spreadsheets Modified Date (https://www.excelbanter.com/excel-discussion-misc-queries/125512-using-spreadsheets-modified-date.html)

HROBERTSON

Using the Spreadsheets Modified Date
 
Is there a formula that can be used in a cell to pull in the spreadsheet's
modified date? I need to figure out a way to automatically add the date of
the last time the workbook was changed. Any help would be greatly
appreciated.

Thank You!

bigwheel

Using the Spreadsheets Modified Date
 
There is a DateLastModified Property available in VBA

"HROBERTSON" wrote:

Is there a formula that can be used in a cell to pull in the spreadsheet's
modified date? I need to figure out a way to automatically add the date of
the last time the workbook was changed. Any help would be greatly
appreciated.

Thank You!


debbieevans

Using the Spreadsheets Modified Date
 
Sorry i dont know VBA and cant access my help, please can you tell me how to
the modified date into a cell?

"bigwheel" wrote:

There is a DateLastModified Property available in VBA

"HROBERTSON" wrote:

Is there a formula that can be used in a cell to pull in the spreadsheet's
modified date? I need to figure out a way to automatically add the date of
the last time the workbook was changed. Any help would be greatly
appreciated.

Thank You!



All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com