have a look at UserLibraryPath Property in excel vba help.
--
jb


"Desaivres Alain" wrote:

Hi

I am deploying an xla applications on tens of computers spread all over the
world and am wondering how I can get automaticaly (vbs script) the default
location for Addins...

Most of the time such a path will work
WshShell.ExpandEnvironmentStrings ("%APPDATA%"&"\Microsoft\AddIns\")

BUT I also know that on French machines the final path is not
"\Microsoft\AddIns\" but
"&"\Microsoft\Macro Complementaire\"

So is there someone who would know
- how many different locations exist ?
- how to find a way to automatically recover the exact location of a given
machine
My intention being to do that through a vbs script...

Thanks to you
Kind Regrads
Alain