Login    Forum    Register    Search    FAQ

Board index » HELP AND ADVICE » G33K'S CORNER




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Excel Modified Date
 Post Posted: Fri May 11, 2007 12:12 pm 
Offline
The Groundkeeper
User avatar

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?

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Excel Modified Date
 Post Posted: Fri May 11, 2007 12:17 pm 
Offline
it is I! Diabetes man!
User avatar

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

_________________
Image



Image
Went to a zoo, they only had one animal there, a dog............. It was a shitzu....



I’z leakin… bring amberlamps


Top 
 Profile  
 
 Post subject:
 Post Posted: Fri May 11, 2007 1:01 pm 
Offline
Stat Whore
User avatar

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?

_________________
Image
OGame FAQ


Top 
 Profile  
 
 Post subject:
 Post Posted: Fri May 11, 2007 1:04 pm 
Offline
The Groundkeeper
User avatar

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.

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Excel Modified Date
 Post Posted: Fri May 11, 2007 1:23 pm 
Offline
Bow down to the master
User avatar

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

:lol: :lol: :lol: :lol: :lol:

_________________
Codito Ergo Sum | Even i, who have no clue about social life
Image


Top 
 Profile  
 
 Post subject:
 Post Posted: Fri May 11, 2007 2:04 pm 
Offline
Comin' outta Gallifrey
User avatar

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


Top 
 Profile  
 
 Post subject:
 Post Posted: Tue May 15, 2007 10:14 pm 
Offline
The Groundkeeper
User avatar

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

_________________
Image


Top 
 Profile  
 
 Post subject:
 Post Posted: Tue May 15, 2007 10:21 pm 
Offline
Saints ftw!!
User avatar

Joined: Fri Apr 23, 2004 6:22 pm
Posts: 7877
Location: /dev/null
try that :?:

_________________
Insert unfunny comment here ->


Top 
 Profile  
 
 Post subject:
 Post Posted: Tue May 15, 2007 10:46 pm 
Offline
The Groundkeeper
User avatar

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..... :(

_________________
Image


Top 
 Profile  
 
 Post subject:
 Post Posted: Tue May 15, 2007 10:47 pm 
Offline
Comin' outta Gallifrey
User avatar

Joined: Mon Aug 01, 2005 9:44 pm
Posts: 7821
Location: banging with enamor
:oops:

_________________
“There are some people in this world who don’t love their fellow man, and I HATE people like that!”


Top 
 Profile  
 
 Post subject:
 Post Posted: Wed May 16, 2007 7:43 am 
Offline
Saints ftw!!
User avatar

Joined: Fri Apr 23, 2004 6:22 pm
Posts: 7877
Location: /dev/null
Ezer is the one you need :wink:

_________________
Insert unfunny comment here ->


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 11 posts ] 

Board index » HELP AND ADVICE » G33K'S CORNER


Who is online

Users browsing this forum: No registered users and 0 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
  • Shoutbox
  • Shout Message


test