Can Excel actually point to filenames on disk?
I have an Excel worksheet that displays the names of files on my hard
disk.
But I want the names to be actual pointers to the files, not just
names, so that if I rename or even move a file, its path will
automatically update in the worksheet.
Currently, I've gotta remember to update the sheet every time I rename
or move a file.
Altho' my ultimate purpose is hyperlinks, I'd settle for this
capability in any context.
If as I suspect the Excel/Windows team can't do it, then can I, say,
embed some Microsoft object into a cell that does?
Thanks much.
***
|