ParadigmAPC

How would you retrieve a worksheets Modified and Created Dates
I cant seem to find a method or property that points to them.

Thanks


Re: Visual Studio Tools for Office Excel Retrieve Worksheet Modified and Created Dates

Dennis Wallentin

Check out the property BuiltinDocumentProperties of the workbook, in particular:

Code Snippet

BuiltinDocumentProperties("Creation Date")

BuiltinDocumentProperties("Last Save Time")






Re: Visual Studio Tools for Office Excel Retrieve Worksheet Modified and Created Dates

ParadigmAPC

I can only access BuiltinDocumentProperties from a Workbook, which was something I was looking for, but I am also trying to find the Creation Date and Last Save Time for individual worksheets. Do you know a way of retrieving those values

Thanks for the help so far.





Re: Visual Studio Tools for Office Excel Retrieve Worksheet Modified and Created Dates

Dennis Wallentin

Since all worksheets are part of a workbook's worksheets collection there is no straightful way to achieve what You want.

# Creation date

You can use the NewSheet event of the Workbook and add a datestamp into a cell in the added worksheet (or somewhere else)

#Last Save Time

When a workbook is saved then all the worksheets included are saved at the same time.






Re: Visual Studio Tools for Office Excel Retrieve Worksheet Modified and Created Dates

ParadigmAPC

That would make sense. Thanks