demo's from the immediate window:
dt = Filedatetime("C:\data\KZ081-Default Survey1.xls")
? cdate(clng(dt))
3/18/02
? dt-clng(dt)
6:08:40 AM

Signature
Regards,
Tom Ogilvy
> I have a list of file names with their full name (ie Path + Name) in column
> A. 50 files total. Is there a macro or funtion that I can return the last
[quoted text clipped - 3 lines]
>
> Steven
Tom Ogilvy - 21 Jan 2006 22:11 GMT
? dt-clng(dt)
6:08:40 AM
should be
? dt-int(dt)
6:08:40 AM

Signature
Regards,
Tom Ogilvy
> demo's from the immediate window:
>
[quoted text clipped - 14 lines]
> >
> > Steven
One way:
Option Explicit
Sub testme()
Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long
Dim wks As Worksheet
Dim testStr As String
Dim myFileName As String
Dim myDate As Date
Set wks = Worksheets("sheet1")
With wks
FirstRow = 2 'headers in row 1???
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For iRow = FirstRow To LastRow
myFileName = .Cells(iRow, "A").Value
testStr = ""
On Error Resume Next
testStr = Dir(myFileName)
On Error GoTo 0
If testStr = "" Then
.Cells(iRow, "B").Value = "Not Found"
.Cells(iRow, "C").ClearContents
Else
myDate = FileDateTime(myFileName)
With .Cells(iRow, "B")
.NumberFormat = "mm/dd/yyyy"
.Value = Int(myDate)
End With
With .Cells(iRow, "C")
.NumberFormat = "hh:mm:ss"
.Value = myDate - Int(myDate)
End With
End If
Next iRow
End With
End Sub
Although, I think I'd keep the time and date in one cell. And just format it
pretty.
> I have a list of file names with their full name (ie Path + Name) in column
> A. 50 files total. Is there a macro or funtion that I can return the last
[quoted text clipped - 3 lines]
>
> Steven

Signature
Dave Peterson
Steven - 21 Jan 2006 21:26 GMT
Dave:
Thank you for your help. That is a really nice macro. I was looking
through the Macro VB Help for how to get LastSavedBy but could not find
anything. Is there a way to get who saved the file last?
Thanks,
Steven
> One way:
>
[quoted text clipped - 53 lines]
> >
> > Steven
Dave Peterson - 21 Jan 2006 22:28 GMT
Are these Excel files (or MSOffice files)?
If yes, you can use the technique at Chip Pearson's site:
http://cpearson.com/excel/docprop.htm
Look for "Document Properties Of Closed Files"
and be careful. There's instructions for both version 1.2 and 2.0 of that DSO
dll.
> Dave:
>
[quoted text clipped - 67 lines]
> >
> > Dave Peterson

Signature
Dave Peterson