finding AddIns folder

M

mike allen

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
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top