Replace your current macro code to the following:
Change ("YourWorksheet") to the name of the sheet where the file path will be created. This is a combination of the first code I provided and the code I gave you the link for above. It works for me to select the file path and then make that path into a link to the folder you selected. I couldn't get it to work with your original code. This doesn't do exactly what you wanted but it does make it a quick process to open the folder where files are saved so you can open them whenever you want.
Bookmarks