Can Excel actually point to filenames on disk?
Bill:
Thanks much for your reply.
It's pretty much as I expected. The only way to refer to a file being
via filename is a fact I hadn't considered, in those terms.
The macro is a good idea. I also had this nifty thought: Whenever I
rename or move a file, I can do it from within the worksheet. I
suppose it could be done with a macro: While on the cell containing a
filename, I can have the macro launch a file dialog, on exit from
which it'd update the filename in the cell.
Thanks again.
***
|