Creating a shortcut Folder

[sassriverrat]

Good Evening,

I'm attempting to get excel to generate a shortcut in location "A1" for the save folder of the workbook, as specified in "A2". I posted this about a week ago with a sample piece of code that I had found but I wasn't sure how to adapt it and another user just reposted the same code I did. I was hoping someone might be able to either clean it up or explain to me what I need to tweak to make use of it.

Thanks

this was my previous post

VBA to generate a file shortcut

I'm trying to get a piece a code that can generate a shortcut for a folder I generated via code. It would be really nice if I could change the icon as well to an object that's on a page in the workbook, but that's secondary. So: 1. Makes an shortcut for a folder specified in code. 2. Makes a...

www.mrexcel.com

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.