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.

Please Login or Register  to view this content.

**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.