Community Bot 1 1 1 silver badge. Behseini Behseini 5, 19 19 gold badges 66 66 silver badges bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Siddharth Rout Siddharth Rout k 16 16 gold badges silver badges bronze badges.
Glad to be of help : — Siddharth Rout. Sub SaveToLocations ' Saves active file to current plus two other backup locations, appends system date and time in front of file name in backup locations. Name ActiveWorkbook. Save End Sub.
Mike Mike 15 2 2 bronze badges. Sign up or log in Sign up using Google. It is invalid in Excel Actually, we can get the both created time and last modified time of current workbook in Document Properties dialog box.
Step 1 : Open the Advanced Properties dialog box:. Step 2 : In the Advanced Properties dialog box, you will see the created time and last modified time under Statistics tab. See the following screenshot:. The following VBA macros will help you insert the created time and last modified time of current workbook information in cells directly. Insert both created time and last modified time in Excel. VBA code: Insert both created time and last modified time in Excel. Step 3 :Press the F5 key to run this macro.
And then the created date and last modified date will be inserted into cell A1 and cell A2 separately. Note : you can modify the destination cell in the VB according to your needs. Insert last modified time of workbook in Excel. Then it inserts the last modified time in the cell. Insert created time of workbook in Excel. Note: If your cell is not date format, it may display a strange number. Just format this cell as Date format, it will show as a normal date. May I introduce you a handy tool-- Kutools for Excel which including more than useful functions can enhance your working efficiency?
After free installing Kutools for Excel, please do as below:. See screenshot:. Then in the Insert Workbook Information dialog, check the information you want to insert from Information section, then go to specify the location you want to insert to, you can choose cells, footer left footer, centre footer, right footer or header left header, centre header, right header. Click Ok , and the information you check has been inserted to the location you specify.
If you want to have a free trial of the Insert Workbook Information function, please go to free download Kutools for Excel first, and then go to apply the operation according above steps.
Note: The other languages of the website are Google-translated. I'm trying to create a spreadsheet that will let me rename my photos using the date I took the picture since Creation and Last Modified will not work for me. Can you help me with this? Since this is an available field under Windows Explorer in Win7 , so I don't understand why I'm having so much difficulty figuring this out.
AshJT New Member. Joined Aug 18, Messages 1. Hi I'm also looking at something similar to this - I can read metadata from a file by using fso code, but is there a way to change this data? Ideally I want to change the Author data field.
Any ideas? You must log in or register to reply here. Similar threads B. Solved Select Sheet from External Workbook. Replies 5 Views Oct 10, GWteB. Question Microsoft access database form with controls, read text file and convert to csv. ExcelDev Sep 15, Excel Questions.
Replies 1 Views Sep 15, ExcelDev. Taylor August 26, at am. Leave a Reply Cancel reply Your email address will not be published. Continue 4 Comments. Continue 6 Comments. Continue 16 Comments. Continue 1 Comment. Continue No Comments. Terms and Conditions of use. Home About Advertise With Us. Newsletter Get latest updates from exceltip in your mail. Powered by GDPR plugin.
Privacy Overview This website uses cookies so that we can provide you with the best user experience possible. You can adjust all of your cookie settings by navigating the tabs on the left hand side. Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
0コメント