Last Date Modified
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? |
Last Date Modified
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? |
Last Date Modified
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? |
All times are GMT +1. The time now is 09:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com