Get file details

[ChrisUK]

Hi,

I wonder if someone can see what I'm doing wrong here

What I thought was a very simple function. In a worksheet cells I have the file name - GetFileDetails("u:\documents\stuff.txt"). I know the file exists but but I always get an error, when I debug it the error is file not found.

Thanks in anticipation

Chris

Function GetFileDetails(fn As String) As String
'
On Error GoTo ErrHandler

GetFileDetails = FileDateTime("fn")
GoTo EndFunc

ErrHandler:
GetFileDetails = "File Not Found"

EndFunc:

End Function

 

[RoryA]

It should be:

GetFileDetails = FileDateTime(fn)

without the quotes round "fn".

 

[ChrisUK]

It should be:

GetFileDetails = FileDateTime(fn)

without the quotes round "fn".

AHHHHHHHHHHHHHHHHHHH I was looking at that for ages! Funny how the obvious things always evade you.

Thanks

Chris