Open an external file from excel and store the file path in a cell

[sg401]

This may sound odd, but I was looking for ways to create a macro that would open a a dialog box that would prompt the user for a file that would then store that filepath to a cell, allowing the user to click on the cell to open it again.

The excell sheet would serve as a checklist for many different users and would allow them to append documents (word, excel, powerpoint, jpeg) to certain item numbers in the excel spread sheet as references as back up for their data/comments.

An example of how i envision this working is the individual would click on a button linked to a cell, that button would bring up the dialog box that would allow the user to browse and open a file, that file would then be linked to that cell within the spreadsheet. Any help with this would be greatly appreciated.

 

[fredmcted]

i could suggest to look in the quick access toolbar options in the file tab and then record a macro, this may be what you want not sure, hope it helps

 

[sg401]

Hey Fred,

I've tried that but it does not record a macro that I could easily use. Just a one line code. I would like to be able to click on an image located in cell A2, then have a prompt ask for a file, attach a file like a word doc or image (basically hyperlink the file), then have that filepath stored to that image in cell A2 so that whenever i clicked on it the file would open up.