File Date And Time

Public Function File_Date_And_Time(StrFileSpec As String) As String

On Error GoTo File_Date_And_Time _ErrorHandler
‘====================================================================================================
‘This function returns the DATE and TIME (of CREATION) of the supplied filename
‘====================================================================================================

________File_Date_And_Time = CStr(FileDateTime(StrFileSpec))
Exit Function

‘====================================================================================================
‘At this juncture an error has returned therefore return a NULL string
‘====================================================================================================

File_Date_And_Time _ErrorHandler:
________File_Date_And_Time = “”
End Function

Advertisement

~ by userdefinedfunctionsinvba on September 11, 2009.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.