Author |
Message |
Caspius=GCHQ=
|
Post subject: Excel Modified Date Posted: Fri May 11, 2007 12:12 pm |
|
|
The Groundkeeper |
|
Joined: Fri Mar 26, 2004 7:59 pm Posts: 6056 Location: UK
|
Is there anyway of grabbing the last modified date of the file, the last time it was saved, and putting that into a cell?
_________________
|
|
|
|
|
nicey=GCHQ=
|
Post subject: Re: Excel Modified Date Posted: Fri May 11, 2007 12:17 pm |
|
|
it is I! Diabetes man! |
|
Joined: Wed Mar 03, 2004 1:15 pm Posts: 14174 Location: anywhere but nowhere
|
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
_________________ Went to a zoo, they only had one animal there, a dog............. It was a shitzu.... I’z leakin… bring amberlamps
|
|
|
|
|
Apocalypse
|
Post subject: Posted: Fri May 11, 2007 1:01 pm |
|
|
Stat Whore |
|
Joined: Sat Oct 22, 2005 2:26 am Posts: 3152 Location: Ireland
|
you could just enter them in manually
are you talking about an automated way of doing it?
_________________
OGame FAQ
|
|
|
|
|
Caspius=GCHQ=
|
Post subject: Posted: Fri May 11, 2007 1:04 pm |
|
|
The Groundkeeper |
|
Joined: Fri Mar 26, 2004 7:59 pm Posts: 6056 Location: UK
|
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.
_________________
|
|
|
|
|
Chadk
|
Post subject: Re: Excel Modified Date Posted: Fri May 11, 2007 1:23 pm |
|
|
Bow down to the master |
|
Joined: Thu Aug 12, 2004 12:59 pm Posts: 1840
|
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
_________________ Codito Ergo Sum | Even i, who have no clue about social life
|
|
|
|
|
elbow=GCHQ=
|
Post subject: Posted: Fri May 11, 2007 2:04 pm |
|
|
Comin' outta Gallifrey |
|
Joined: Mon Aug 01, 2005 9:44 pm Posts: 7821 Location: banging with enamor
|
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
_________________ “There are some people in this world who don’t love their fellow man, and I HATE people like that!”
|
|
|
|
|
Caspius=GCHQ=
|
Post subject: Posted: Tue May 15, 2007 10:14 pm |
|
|
The Groundkeeper |
|
Joined: Fri Mar 26, 2004 7:59 pm Posts: 6056 Location: UK
|
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
_________________
|
|
|
|
|
GeneralPublic=GCHQ=
|
Post subject: Posted: Tue May 15, 2007 10:21 pm |
|
|
Saints ftw!! |
|
Joined: Fri Apr 23, 2004 6:22 pm Posts: 7877 Location: /dev/null
|
try that
_________________ Insert unfunny comment here ->
|
|
|
|
|
Caspius=GCHQ=
|
Post subject: Posted: Tue May 15, 2007 10:46 pm |
|
|
The Groundkeeper |
|
Joined: Fri Mar 26, 2004 7:59 pm Posts: 6056 Location: UK
|
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.....
_________________
|
|
|
|
|
elbow=GCHQ=
|
Post subject: Posted: Tue May 15, 2007 10:47 pm |
|
|
Comin' outta Gallifrey |
|
Joined: Mon Aug 01, 2005 9:44 pm Posts: 7821 Location: banging with enamor
|
_________________ “There are some people in this world who don’t love their fellow man, and I HATE people like that!”
|
|
|
|
|
GeneralPublic=GCHQ=
|
Post subject: Posted: Wed May 16, 2007 7:43 am |
|
|
Saints ftw!! |
|
Joined: Fri Apr 23, 2004 6:22 pm Posts: 7877 Location: /dev/null
|
Ezer is the one you need
_________________ Insert unfunny comment here ->
|
|
|
|
|
|