How do I creating a shortcut (link) in a folder?

[LoneWolf3574]

Thanks to all the posts on the wonderful forums, I've been able to create a number of macros to make data entry for my coworkers much easier. However, a few of them are completely computer illiterate and I'm trying to make things as simple as possible for them. I've generated a macro that will open a general format xlsm file and save it back to its directory as another file name and then close that workbook, this will change from month to month as each file only tracks information for that month. What I need to do now is create something that, when clicked, will make a shortcut/link back into a commonly named folder on their desktop. It's not a shared folder, but if I have something that everyone can use to copy or make a link back to their shortcut folder (U:\shortcuts) when activated, I'm hoping that will work for them. Thank you all.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[LoneWolf3574]

I get a "Run-time error '440': The shortcut pathname must end with .lnk or .url". It works fine up until that point.

Please Login or Register  to view this content.

PS - I shortened the pathnames to visually clean it up for others, otherwise the code is the same

[patel45]

Please Login or Register  to view this content.

[LoneWolf3574]

Thank you, it works just like I want now. My apologies for my ignorance on that ".lnk", I'm still really new to this.