modification date for a file

**neta** · 05-05-2009, 11:47 AM

hi,
How can I retreive into a VBA code the date of the last modification of a different excel file ?
Can I retreive rhe name of the execel file creator ?

Thanks, Neta

**Leith Ross** · 05-05-2009, 12:06 PM

Hello neta,

Here is an example using the File System Object. This works with Excel 2000 and up.

Sub Macro1()

  Dim FileName As String
  Dim FSO AS Object
  Dim LastMod As Variant

    FileName = " "  'Add the Workbook name along with the path between the quotes

    Set FSO = CreateObject("Scripting.FileSystemObject")
    LastMod = FSO.GetFile(FileName).DateLastModified

    Set FSO = Nothing

End Sub

**neta** · 05-05-2009, 12:15 PM

Thanks a lot...
Can I have the file creator ?

Neta

**Leith Ross** · 05-05-2009, 12:18 PM

Hello neta,

If you are referring to the "Creator" property, this is only available on the MAC version of Excel.

**neta** · 05-05-2009, 12:22 PM

Thanks a lot,

What are the available properties in the PC Excel ?

**Leith Ross** · 05-05-2009, 12:31 PM

Hello neta,

On the PC, there is no way to know what program created the file. The assumption would be it was created by the application for the file type. In the case of a workbook, it would be Excel.