To find Date of file creation
How to find the date of creation of excel file without VB.
Last edited by unas; 12-14-2010 at 12:25 AM.
Using Windows Explorer, right click on the file name. Select Properties. Select the Details Tab. Scroll down to Content Created under the Origin section. I am not sure if this information can be retrieved within the spreadsheet itself. If you are willing to create a UDF, then look here
http://en.allexperts.com/q/Excel-105...y-function.htm
Alan
Last edited by alansidman; 12-09-2010 at 12:59 PM.
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
In Excel 2003 (while the workbook is open) it's in "File > Properties", on the Statistics tab.
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
I want an excel function where i can get the date of creation of a file automatically and use the same in my subsequent formula for calculating.
i hope im clear.
thanking you,
Did you read the article I posted for you. It tells you how to create a function to do this. There is no current Excel function to allow you to do this. You will need to create one if that is the direction you want to go. It is simple to do if you follow the example.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks