Displaying File Timestamp of Another Excel File

On Jul 22, 7:17 pm, Bill Manville <Bill-Manvi... RemoveThis @msn.com> wrote:
> Put this in a standard module in your workbook:
>
> Function FileDate(FileName As String) As Date
>   Application.Volatile
>   FileDate = FileDateTime(FileName)
> End Function
>
> Put this in a cell in a worksheet in your workbook
> =FileDate("C:\Temp\MyFile.xls")  [amend as appropriate]

Thanks, Bill, but for some reason I get a "#NAME?" error after pasting
the function
in the VB editor for that sheet, and putting the "=FileDate()" in a
cell in my workbook.
Suggestions? I am in an office with MS Office permissions tightly
controlled, so I cannot
download add-ins or install new software without Helpdesk
intervention.

Did you put the function in a General module?
Did you allow macros to run when you opened the workbook?

And you did really put the full path to the other file in your formula, right?

=FileDate("C:\Temp\MyFile.xls")

rockfalls3 DeleteThis @yahoo.com wrote:
>
> On Jul 22, 7:17 pm, Bill Manville <Bill-Manvi... DeleteThis @msn.com> wrote:
> > Put this in a standard module in your workbook:
> >
> > Function FileDate(FileName As String) As Date
> > Application.Volatile
> > FileDate = FileDateTime(FileName)
> > End Function
> >
> > Put this in a cell in a worksheet in your workbook
> > =FileDate("C:\Temp\MyFile.xls") [amend as appropriate]
>
> Thanks, Bill, but for some reason I get a "#NAME?" error after pasting
> the function
> in the VB editor for that sheet, and putting the "=FileDate()" in a
> cell in my workbook.
> Suggestions? I am in an office with MS Office permissions tightly
> controlled, so I cannot
> download add-ins or install new software without Helpdesk
> intervention.

--

Dave Peterson