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

John,

Check out the GetOpenFileName method.

Filename = Application.GetOpenFilename

For copying the file, check out the CopyFile method.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"John" wrote in message
om...
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