Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find the Powerpoint addins path with VBA ?

385 views
Skip to first unread message

jm.almeras

unread,
Jan 28, 2010, 5:55:17 PM1/28/10
to
Dear VBA / Office experts,

Can anyone tell me how to find the path where addins are stored by
Powerpoint, especially when there are no addins which have been added yet
(otherwise it is easy : addins(1).Path)

Please note that when a Powerpoint user saves a presentation and chooses the
addin type (.ppa), Powerpoint automatically proposes the right folder for
saving the file. Where is the information stored as to that folder ?

Thank you

Jean-Marie

Steve Rindsberg

unread,
Jan 29, 2010, 12:00:14 PM1/29/10
to

Add-ins can be stored anywhere, but it seems you're looking for the default
add-ins path. This may vary by version, so it'd be best to do a little testing
for each.

Start a new presentation, choose Save As and pick PPA or PPAM, as appropriate,
then note the path where PPT proposes to save it.

When I do this here in 2007 or 2003, it defaults to:

Documents and Settings\[username]\Application Data\Microsoft\AddIns


Chirag

unread,
Jan 30, 2010, 8:14:59 AM1/30/10
to
This is very locale dependent. On English versions, this is located at:
Environ("AppData") + "\Microsoft\AddIns"

On French versions, it seems to be located at:
Environ("AppData") + "\Microsoft\Macros compl�mentaires"

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"jm.almeras" <jm.al...@nospam.niet> wrote in message
news:uGoL5zGo...@TK2MSFTNGP05.phx.gbl...

Chirag

unread,
Jan 30, 2010, 9:21:09 AM1/30/10
to
I have added a function that correctly determines the Add-Ins folder in all
Windows versions and all locales. Look at it at:
http://officeone.mvps.org/vba/addin_location.html

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"Chirag" <Chi...@discussions.microsoft.com> wrote in message
news:OkO654ao...@TK2MSFTNGP05.phx.gbl...

jm.almeras

unread,
Jan 30, 2010, 11:34:07 AM1/30/10
to
Thank you Chirag I could not hope for a better answer !

"Chirag" <Chi...@discussions.microsoft.com> a �crit dans le message de
news:eH6w3dbo...@TK2MSFTNGP04.phx.gbl...

0 new messages