Pinned files folder path

Formula11

Active Member
Joined
Mar 1, 2005
Messages
440
Office Version
  1. 365
Platform
  1. Windows
Is there a folder path where pinned files are stored?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
I don't know much about pinned files but what I know is it isn't a simple folder path like regular shortcuts. These pinned items are stored in a database file within your user profile directory. The exact location can vary depending on the version of Windows you're using. If you need to access pinned items programmatically or perform some operations on them, you might need to use Windows API or some specialized tools.

I found this general path for Windows 10:
Rich (BB code):
C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar
 
Upvote 0
Thanks for looking into Cubist.

Do you know if the Pinned files can be placed somewhere like the Quick Access Toolbar.
 
Upvote 0
To my (limited) knowledge, Microsoft Excel doesn't offer a direct way to pin files to the Quick Access Toolbar like you can with commands or macros. With VBA, you could create a macro that opens specific files and then add buttons for those macros to the QAT or a custom ribbon tab.
 
Upvote 0
OK thanks, that's what I was trying to do with the Pinned files but the issue seems to be the folder path.
 
Upvote 0

Forum statistics

Threads
1,216,269
Messages
6,129,813
Members
449,538
Latest member
cookie2956

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top