Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 file/properties to view created date/time how in 2007? Bald Eagle Boy Excel Discussion (Misc queries) 2 June 27th 12 09:11 PM
Windows file property access Sajit Excel Programming 0 December 19th 07 06:16 AM
how can I access favorites in the Excel 2007 Open file command GrahamC Excel Discussion (Misc queries) 0 August 23rd 07 12:40 AM
how can I access favorites in the Excel 2007 Open file command GrahamC Setting up and Configuration of Excel 0 August 23rd 07 12:36 AM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 02:22 AM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"