Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create/modify date for specific sheets?
Hi,
Is there a way to find out the create date or modify date for specific sheets in a workbook? TIA, Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create/modify date for specific sheets?
Nope... You can build something in via macros but it is a bit of work.
-- HTH... Jim Thomlinson "Steve Vincent" wrote: Hi, Is there a way to find out the create date or modify date for specific sheets in a workbook? TIA, Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create/modify date for specific sheets?
Steve has an interesting question!
Jim, that is correct, but do you really think this can be done with macro? unless this is stored within the raw file itself and if we could some how read the raw file to figure it out, because i don't see any property or method which gives this information. -kc "Jim Thomlinson" wrote: Nope... You can build something in via macros but it is a bit of work. -- HTH... Jim Thomlinson "Steve Vincent" wrote: Hi, Is there a way to find out the create date or modify date for specific sheets in a workbook? TIA, Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create/modify date for specific sheets?
Nothing is fool proof in macros but using the change event and the On
Open/Before Close events we can monitor the state of the file. Use the change event to track updates to existing / new sheets. On open inventory the existing sheets. On close write any changes to the sheet inventory. This is only really necessary if we want to track sheets that get deleted. If I were doing it I would write the Created / Last Changed dates metadata to named ranges that are local to each sheet. Additionally I would probably track the username that made the changes. Deleted sheets would be store in application level named ranges. Or the metadata can be sotred in a very hidden sheet but that is actually a shade more work. -- HTH... Jim Thomlinson "KC" wrote: Steve has an interesting question! Jim, that is correct, but do you really think this can be done with macro? unless this is stored within the raw file itself and if we could some how read the raw file to figure it out, because i don't see any property or method which gives this information. -kc "Jim Thomlinson" wrote: Nope... You can build something in via macros but it is a bit of work. -- HTH... Jim Thomlinson "Steve Vincent" wrote: Hi, Is there a way to find out the create date or modify date for specific sheets in a workbook? TIA, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a formula in Excel - count by a specific date | Excel Worksheet Functions | |||
specific totals from sheets represented on other sheets | Excel Discussion (Misc queries) | |||
modify a macro to apply to a specific range of cells | Excel Discussion (Misc queries) | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) |