I want to make an up-to-date list with Excel of file names in a specific directory. They are stories. Another person is monitoring my progress.
Columns are: Last-Modified-Date, File-Name, Pct-Complete and Issues. I have added comments to most of the names' cells and hyperlinked them to the actual files.
Problem: I hoped to use Fx FileDateTime("full path name") in each cell of the Last Modified Field to keep that field up to date.
Despite all kinds of examples and praise for that VBA function, it simply doesn't work; all I get is #NAME.
What is going on?
Bookmarks