Selecting filename in cell from file browser

  • Thread starter Thread starter John
  • Start date Start date
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
 
John,

Check out the GetOpenFileName method.

Filename = Application.GetOpenFilename

For copying the file, check out the CopyFile method.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
VBA: Read picture filename 3
Open file from website, where filename changes 2
searching filenames 1
Excel VBA SQL Query Filename 3
Reference filename used in code from cell 5
Displaying zeros in cells 2
Filename in Excel Cell Address 7

Back
Top