Find the Powerpoint addins path with VBA ?

[jm.almeras]

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]

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 ?

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]

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

 

[Chirag]

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

 

[jm.almeras]

Thank you Chirag I could not hope for a better answer !