Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Access the Content Created File property in vba
Hi
I have just changed job and have upgraded from excel 2003 to 2007 and I use to use the date created property in getfile().datecreated to find out when the workbook was created now this doesn’t work Say for instance the original creator creates a workbook and then emails it to me when i open that workbook the creation date changes to the time I opened it. I have noticed another property in the file properties menu for the workbook of content created which is the correct date that i want to use. My question is how can I access this property so I can see how old a file is rather than when I created it on my computer or if there is another way to see how old the workbook is that would be also greatly appreciated. Regards Kelvan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Access the Content Created File property in vba
scratch the above i have done some mroe playing and it appears the value ActiveWorkbook.BuiltinDocumentProperties.Item(11). Value is the content created date not the date created date in the properties menu
though i am getting an error method value of object documentproperty failed on any files i create but i dont need to worry about that for what i need to do information posted if anyone else is having an issue |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Access the Content Created File property in vba
Hi,
Am Tue, 24 Jul 2012 15:54:32 -0700 (PDT) schrieb : scratch the above i have done some mroe playing and it appears the value ActiveWorkbook.BuiltinDocumentProperties.Item(11). Value is the content created date not the date created date in the properties menu though i am getting an error method value of object documentproperty failed try: ActiveWorkbook.BuiltinDocumentProperties(11) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Access the Content Created File property in vba
that made no difference positively or negatively to the result still works for others spreadsheets but not mine
Regards Kelvan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 file/properties to view created date/time how in 2007? | Excel Discussion (Misc queries) | |||
Windows file property access | Excel Programming | |||
how can I access favorites in the Excel 2007 Open file command | Excel Discussion (Misc queries) | |||
how can I access favorites in the Excel 2007 Open file command | Setting up and Configuration of Excel | |||
Network access to file - read only property | Excel Discussion (Misc queries) |