Creating a shortcut Folder

Status
Not open for further replies.

sassriverrat

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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,868
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,118,765
Messages
5,574,108
Members
412,571
Latest member
Ventura7
Top