Selecting filename in cell from file browser

J

John

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
 
E

Earl Kiosterud

John,

Check out the GetOpenFileName method.

Filename = Application.GetOpenFilename

For copying the file, check out the CopyFile method.
 
Top