ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   file creation date (https://www.excelbanter.com/excel-worksheet-functions/43219-file-creation-date.html)

munken

file creation date
 

how do I insert the date where the workbook was originally created, in
a cell ?

Can I use a function? do I have to program Visual Basic to do this ?

Your input (and hopefully a solution) will be valued :)


--
munken
------------------------------------------------------------------------
munken's Profile: http://www.excelforum.com/member.php...o&userid=26821
View this thread: http://www.excelforum.com/showthread...hreadid=400740


dominicb


Good afternoon Munken

I have an add in available free of charge to anyone requesting it that
will do just this, though a custom written VBA routine, as well as
plenty of other things. If you would like this please send me an
e-mail.

HTH

DominicB



--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=400740


William


range("A1")= ThisWorkbook.BuiltinDocumentProperties("Creation Date")
--


XL2003
Regards

William



"munken" wrote in
message ...

how do I insert the date where the workbook was originally created, in
a cell ?

Can I use a function? do I have to program Visual Basic to do this ?

Your input (and hopefully a solution) will be valued :)


--
munken
------------------------------------------------------------------------
munken's Profile:
http://www.excelforum.com/member.php...o&userid=26821
View this thread: http://www.excelforum.com/showthread...hreadid=400740





All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com