Creating a shortcut Folder

Status
Not open for further replies.

sassriverrat

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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
51,128
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,119,236
Messages
5,576,897
Members
412,752
Latest member
LUIS SAMANO
Top