I need help in setting up a cell to reflect the Last Date Modified of a Word
Document. I did try Google but I don't fully understand the code that they
are saying to use... is there someone who can walk me through how to do this?

You can try this UDF which will get you the date and time of any file. If you
are new to UDF set the Security level to low/medium in
(Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below code. Save. Get back to
Workbook.

Function GetFileDateTime(strFile)
GetFileDateTime = FileDateTime(strFile)
End Function

To use this from cell; try this formula
(pass the full path)
=GetFileDateTime("c:\temp.doc")

PS: You will have to recalculate if the file is saved again.

If this post helps click Yes
---------------
Jacob Skaria


"snickers22" wrote:

I need help in setting up a cell to reflect the Last Date Modified of a Word
Document. I did try Google but I don't fully understand the code that they
are saying to use... is there someone who can walk me through how to do this?

Forgot to mention to format the cell to date/time format of your choice..

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

You can try this UDF which will get you the date and time of any file. If you
are new to UDF set the Security level to low/medium in
(Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below code. Save. Get back to
Workbook.

Function GetFileDateTime(strFile)
GetFileDateTime = FileDateTime(strFile)
End Function

To use this from cell; try this formula
(pass the full path)
=GetFileDateTime("c:\temp.doc")

PS: You will have to recalculate if the file is saved again.

If this post helps click Yes
---------------
Jacob Skaria


"snickers22" wrote:

I need help in setting up a cell to reflect the Last Date Modified of a Word
Document. I did try Google but I don't fully understand the code that they
are saying to use... is there someone who can walk me through how to do this?