- #SET FILE MODIFCATION TIME TO OLDEST FILE TIME INSTALL#
- #SET FILE MODIFCATION TIME TO OLDEST FILE TIME PLUS#
NOTES: The FTP server must support the MDTM (get) and MFMT (set) commands in order to get these methods take effect. The FTP server returns time in the format of YYYYMMDDhhmmss (ISO 3077) which is equivalent to yyyyMMddHHmmss as in Java date time pattern. boolean setModificationTime(String filePath, String time).String getModificationTime(String filePath).So, both dates are covered for me.the one on the General tab using Properties Plus, and the other on the Statistics tab using said macros.In Java FTP programming with Apache Commons Net API, it’s possible to get and set modification time of a specific file on FTP server, using the following methods of the FTPClient class:
In both cases the General tab's Created date remained unchanged from the macros, which makes sense because it is a different property. ThisWorkbook.BuiltinDocumentProperties("Creation Date") = Date - 5Īnd it gave a Statistics tab date of March 18, 2005, 5 days ago. ThisWorkbook.BuiltinDocumentProperties("Creation Date") = DateĪnd it changed the Statistics tab's Created date to today. Just now, on a test file that i had created 2 weeks ago I ran the following macro: The Statistics tab shows the date when the file was created. On the General tab, "Created" refers to the date when the file was saved on the computer for the first time. Those two dates have the same title of "Created" but there is a difference. I do see on my Statistics tab that the Created date is unchanged, similar to what you see. On my General tab, the "Created" date shows the date I changed the file to in WE using PP. Your Summary tab's position (#3 where mine is #2) and interface (mine has clearly defined fields like a dataform) are different. What version are you using? On my xl2k3 Properties dialog, I have 5 tabs (you have 3), in the order General, Summary, Statistics, Contents, Custom. Well, it looks like our versions are different nonetheless. Hopefully this will get you closer to whatever it is you are trying to accomplish.
#SET FILE MODIFCATION TIME TO OLDEST FILE TIME PLUS#
Then in Explorer, navigate to your file, right click on it, choose the Properties Plus menu option, and change the property(ies) you want to change, the Creation date being among the possibilities.
#SET FILE MODIFCATION TIME TO OLDEST FILE TIME INSTALL#
Here is the url (it's available elsewhere but here's one place, and it's free):Īfter you click the download link, and after it downloads, go into Explorer and double click it to install it. As most people can probably tell by now, I'm not crazy about downloads generally, but this one, called PropertiesPlus, is able to manipulate the Creation date, which VBA is unable to do, so I tried it and it seems to work, if I correctly understand the objective of your post. If you want a date in the past, then there is a download that can do that. Save that new workbook which would give you a Today date of creation. If you have VBA then you'd need to export those modules too. right click on the sheet and hit Move or Copy > Create a copy > New book). If you want to put the date in the future, for example if that future date is today's date (being "future" from the perspective of the Decemdate), then select all the sheets in your workbook and copy them (i.e. Let's say the file was created on December 20, 2003.
If you want to change the creation date from what it is now, then you will want to either place the date in the future or in the past. Maybe API calls can do it but I don't know what they are. Aside from creating a new file, Excel has no built-in way to do this that I am aware of.
0 kommentar(er)
