Gamecommunity =GCHQ=
http://82.148.227.125:8080/

Excel Modified Date
http://82.148.227.125:8080/viewtopic.php?f=122&t=41317		 Page 1 of 1
Author:  Caspius=GCHQ= [ Fri May 11, 2007 12:12 pm ]
Post subject:  Excel Modified Date
Is there anyway of grabbing the last modified date of the file, the last time it was saved, and putting that into a cell?
Author:  nicey=GCHQ= [ Fri May 11, 2007 12:17 pm ]
Post subject:  Re: Excel Modified Date
Caspius=GCHQ= wrote:
Is there anyway of grabbing the last modified date of the file, the last time it was saved, and putting that into a cell?

only if its the 31st of february
Author:  Apocalypse [ Fri May 11, 2007 1:01 pm ]
Post subject: 
you could just enter them in manually

are you talking about an automated way of doing it?
Author:  Caspius=GCHQ= [ Fri May 11, 2007 1:04 pm ]
Post subject: 
Apocalypse=GCHQ= wrote:
you could just enter them in manually

are you talking about an automated way of doing it?


I am, just wondered if there was a automated way of doing it.
Author:  Chadk [ Fri May 11, 2007 1:23 pm ]
Post subject:  Re: Excel Modified Date
MrNiceGuy=GCHQ= wrote:
Caspius=GCHQ= wrote:
Is there anyway of grabbing the last modified date of the file, the last time it was saved, and putting that into a cell?

only if its the 31st of february

:lol: :lol: :lol: :lol: :lol:
Author:  elbow=GCHQ= [ Fri May 11, 2007 2:04 pm ]
Post subject: 
Caspius=GCHQ= wrote:
Apocalypse=GCHQ= wrote:
you could just enter them in manually

are you talking about an automated way of doing it?


I am, just wondered if there was a automated way of doing it.


yes, you can do it with VBA probably.

http://techonthenet.com/excel/formulas/filedatetime.php
Author:  Caspius=GCHQ= [ Tue May 15, 2007 10:14 pm ]
Post subject: 
Found this but how do you actually use it from the Spreadsheet...

Code:
Public Function ModDate()
ModDate = Format(FileDateTime(ThisWorkbook.FullName), "m/d/yy h:n ampm")
End Function
:?

http://www.mrexcel.com/archive/Dates/17403b.html
Author:  GeneralPublic=GCHQ= [ Tue May 15, 2007 10:21 pm ]
Post subject: 
try that :?:
Author:  Caspius=GCHQ= [ Tue May 15, 2007 10:46 pm ]
Post subject: 
GeneralPublic=GCHQ= wrote:
try that :?:


Haha thanks, that sorted it. Been trying to suss that out for ages. I had to create a new module rather than just pasting it into the spreadsheet code section in VBE. Can't believe nobody uses Excel here enough to tell me this though..... :(
Author:  elbow=GCHQ= [ Tue May 15, 2007 10:47 pm ]
Post subject: 
:oops:
Author:  GeneralPublic=GCHQ= [ Wed May 16, 2007 7:43 am ]
Post subject: 
Ezer is the one you need :wink:
Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/