Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding AddIns folder
Where in the world is the AddIns folder that comes up when you save as .xla?
If I create an .xla by saving as..., I see it, but I cannot find it in that file path on windows explorer. I also searched for and found 2 more folders called AddIns, but neither folder holds the .xla I created by saving as ..xla. Very confusing, but I would like to move all of my .xla's into the same AddIns folder I see when excel suggests where to save as .xla's. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding AddIns folder
Excel looks at the folders named by Application.UserLibraryPath and
Application.LibraryPath. E.g,. Sub AAA() Dim UserLib As String Dim XLLib As String UserLib = Application.UserLibraryPath XLLib = Application.LibraryPath Debug.Print "UserLib:", UserLib Debug.Print "XLLib:", XLLib End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "mike allen" wrote in message ... Where in the world is the AddIns folder that comes up when you save as .xla? If I create an .xla by saving as..., I see it, but I cannot find it in that file path on windows explorer. I also searched for and found 2 more folders called AddIns, but neither folder holds the .xla I created by saving as .xla. Very confusing, but I would like to move all of my .xla's into the same AddIns folder I see when excel suggests where to save as .xla's. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a folder with the largest number. | Excel Discussion (Misc queries) | |||
Finding temp folder. Environment variable? | Excel Programming | |||
Finding the Path to the Program Files Folder | Excel Programming | |||
force addins.add to change folder for an addin | Excel Programming | |||
finding all empty excel files in a folder. | Excel Discussion (Misc queries) |