Get the properties from a closed file

[ericsson]

Hi

Does anyone no some way to get the properties Created: , Modified: and
accessed: from a closed excelfile by a VBA macro.

//Lasse

 

[Harald Staff]

Hi Lasse

See
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q224351
http://www.cpearson.com/excel/docprop.htm

HTH. Best wishes Harald

 

[Sharad]

Hi,

You can use code as under - modify the filename with full path, as
needed.

Sub FileProps()
Dim fs
Dim dtCreated As Date, dtModified As Date, dtAccessed As Date
Set fs = CreateObject("Scripting.FileSystemObject")
Set d = fs.GetFile("c:\Book1.xls")
dtCreated = d.DateCreated
dtModified = d.DateLastModified
dtAccessed = d.DateLastAccessed
MsgBox "Created on " & dtCreated & ", Last Modified on " & _
dtModified & ", Last Accessed on " & dtAccessed

End Sub

Sharad