Selecting filename in cell from file browser
I have an Excel spreadsheet that a user needs to fill out with meta
data and also attach a hard drive link to a document. Is there a way
in Excel to pull up a file explorer window to pick files from their or
network drives, select the filename, and place that in the cell?
Secondly, is there a way to physically copy that file to the same
location as the spreadsheet when they do this?
Thanks for the help in advance.
JR
|