Get a file datestamp prior to opening file.

[pkmoore]

Can someone tell me how to check the datestamp of a file to be sure it is the current file (date of file matches today)prior to opening the file with Excel and manipulating it.

Thanks!!

Pat...

 

[Loomah]

HI
Never quite understood specifically what's meant by date stamp but if you have a look at this link it may well solve your problem. Not something I've ever done and it's bad enough that I'm sat on this site on a Friday night blah blah blah!!

http://www.cpearson.com/excel/docprop.htm

And it's raining
still, Happy Friday
;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[rmikesmith]

Pat,

Here's a sample procedure to determine the date/time stamp of any file:

Sub DateTimeStamp()
Dim FDateTime As Variant
  FDateTime = FileDateTime("Drive:\Directory\Filename.Ext")
  MsgBox FDateTime
End Sub

Insert the path/filename of interest. You can use other VBA functions to extract just the date portion, if necessary.

Or, as a function:

Function DateTimeStamp(FName as String) As Variant
  DateTimeStamp = FileDateTime(FName)
End Function

HTH
Mike

 

[pkmoore]

Thanks for the help. Works Great!!