Macro to link to file location

Hey Guys,

Is there a way to make a macro attached to a button, so that when you click the button it pops up and lets you search through your directly and choose a file? Then when you pick a file, it populates a cell (say, A1) with a hyperlink to that file?

I'm trying to have a way to store locations of Word and Powerpoint documents that relate to different projects in Excel.

Thanks!
Matt

Solved!

Please Login or Register  to view this content.