Creating a shortcut Folder

Status
Not open for further replies.

sassriverrat

Well-known Member
Joined
Oct 4, 2018
Messages
625
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,256
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,279
Messages
5,546,943
Members
410,764
Latest member
Dedeke
Top