getting content-created-date of an excel file
change content created date word
change created date on excel file
how to change modified date of a file in windows 10
excel date created
excel content created
microsoft word document creation date
how to forge a date on a document
My goal is to display the date of an excel file. But : If I download the file from the internet , automaitclly the creation date and modify date are set to current time and date. I looked upon the file's properties , and found that in section 'Details' , under personal infomation , there is a section called 'Source' and there , it has a property called ' Content Created ' with the original date file.
Is there a way to get it to a string ??
You can use the Microsoft DSO OLE Document Properties Reader to get this.
DSOFile.OleDocumentPropertiesClass oleDocumentPropertiesClass = new DSOFile.OleDocumentPropertiesClass(); oleDocumentPropertiesClass.Open("C:\\My Documents\\MyExcelFile.xls"); MessageBox.Show(oleDocumentPropertiesClass.SummaryProperties.DateCreated.ToString());
The DSO file can be downloaded from http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q224/3/51.asp
what is that content created date in microsoft excel and how it is , xlsx file is created on that date but it's content retains the date from the original . xls file and does not get updated. Since the file has been created� In an excel file's properties under detail tab, we have these dates: I can change the "Date Created","Date Modified" and "Date Accessed". (using vb.net) The problem is that I cannot change the other two dates which are "Content Created" and "Date Last Saved".
In VBA you can get the property using
ThisWorkbook.BuiltinDocumentProperties("Creation Date") like this:
Sub GetCreationDate() MsgBox ThisWorkbook.BuiltinDocumentProperties("Creation Date") End Sub
I haven't used c# with Excel though but the MSDN documentation has an example: Workbook.BuiltinDocumentProperties Property (MSDN)
Change "Content Created Date" and "Last Saved Date", In an excel file's properties under detail tab, we have these dates: the other two dates which are "Content Created" and "Date Last Saved". if you create a new thread then there is much more possibilities to get many� In most cases, you probably want File.GetLastWriteTime(). Reason: Creation time will give you the time the file was created on the disk. And, if the file is copied, for example, that time will be updated to reflect that.
Here is an example, JPW should still have his answer marked for the points. Not this one.
Excel.Application eApp = null; Excel.Workbook eBook = null; eApp = new Excel.Application(); eBook = eApp.Workbooks.Open(pathToFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); var docProp = eBook.BuiltinDocumentProperties("Creation Date"); System.DateTime dt = docProp.Value; MessageBox.Show(dt.ToLongTimeString());
Change Content Created date, way to change the content created date, i have used a old sheet i use to To get replies by our experts at nominal charges, follow this link to� Step 1: Hold down the ALT+ F11 keys, and it opens the Microsoft Visual Basic for Applications window. Step 2: Click Insert>> Module, and paste the following macro in the Module Window. VBA code: Insert both created time and last modified time in Excel.
Set the 'Last Saved' and 'Content Created' date fields of Word/Excel , The new version of BulkFileChanger supports the 'Last Saved' and 'Content Created' date properties of Microsoft Office documents (Word,� Hi All Is there a way to change the content created date, i have used a old sheet i use to use but want it to show a different date, i know you can copy all the sheets to a new book and save but doing this the 87 sheets withing the workbook loose some of there shape I have attached you a picture of what i mean as its not the created date in the general tab its the one in the details tab Thanks
How to show "Content Created" date from excel file, Is it somehow possible to get the "content created" information out of my excel workbooks as I can see the "content created" date also in the� Instead of combining binaries, add a custom column with formula =Csv.Document([Content]). This will give you a table with the file contents, which can be expanded without losing the "date modified".
How To Change Excel's File Original Creation Date?, Aside from creating a new file, Excel has no built-in way to do this that I am aware of. If you want to change the creation date from what it is now, then you Hopefully this will get you closer to whatever it is you are trying to accomplish have 3), in the order General, Summary, Statistics, Contents, Custom. The Microsoft Excel FILEDATETIME function returns the date and time of when a file was created or last modified. The FILEDATETIME function is a built-in function in Excel that is categorized as a File/Directory Function. It can be used as a VBA function (VBA) in Excel.
- this worked for me. Please note that you have to add the DSO.dll and reference it to your project. Also , please note that this value can be null. Make sure to take that in mind . thank jac @jac
- Creation date - date is lower case
- Not according to the MSDN page I linked.
- Dim bidp For Each bidp In ThisWorkbook.BuiltinDocumentProperties If bidp.Name = "Creation date" Then MsgBox CStr(bidp.Value) End If Next The Name Value is but it appears yours will work as well, my apologies.
- @Sorceri Maybe it depends on version, I ran your code sample and it works with
Creation date, but so did the sample I provided with
Creation Date. (Using Excel 2010). I tried
CrEaTION DAtEtoo and that worked as well, so I guess it's case insensitive.
- Thank you all for your help . Now I am getting an error on this line : Microsoft.Office.Core.DocumentProperties dp = book.BuiltinDocumentProperties; The excepton is Invalid castException . Why ?