| 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 ->
|
|
| |
|
|
|
