UDF Using FileDateTime

[hughbag]

I created a simple UDF to obtain the date a file was created.

Function FDT(str As String)
FDT = FileDateTime(str)
End Function

The problem I am having is that when I use this function in a cell, the value does not automatcially update when the referenced file is modified. In fact I tried both "calculate now" and saving, closing and re-opening the file. Neither of these worked. I am using Excel 2007.

By chance, my spreadsheet happens to use Views and when I switched views the information was updated!!.

Can anyone give me an idea why the function does not fire automatically when auto recalc is on?

 

[SkipVought]

Hi,

VBA Questions are to be addressed in foorum707.

Try adding a timer to Calculate on a periodic bases.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}