Ditributing ComAddin's & ActiveX-dll's in Vista
 

Vista, with Excel 2000, 2002/3 (don't have 2007 yet but hopefully same
applies) and VB6 dll's

I'm looking for best approach to distribute & register ComAddin's and
ordinary ActiveX dll's (for use with VBA). I also have some particular
questions as indicated below.

I can install a CAI via (Excel) tools ComAddins and/or register a dll
manually or programmatically with Regsrv32 providing:

- I'm logged on as an Administrator
- UAC (User action control) is turned off (requires a restart and
potentially intimidating for normal user).

So, with quite a lot of effort I can install for an Administrator user. I
haven't yet worked out how to install either a CAI or dll for use by a
'Standard User' - would anyone know? Even better, would it be possible to
install CAI and/or dll for all users at the same time, manually and/or
programmatically.

FWIW, I managed to install an old (pre-vista) 3rd party CAI that has its own
install program with UAC turned on. Wonder how it managed to do that, even
with a registry hack (though couldn't get it to install in a Standard User's
account).

Closely related, does anyone have a view as to most suitable folder in which
to place the CAI / dll. Ideally I guess(?) best to place in this 'virtual'
folder -

C:\users\username\AppData\Roaming\Microsoft\Addins \

This is the default UserLibraryPath, at least that's how it appears for me.
It's useful, though not necessary, to install into this path for a number of
reasons. However by default this path is hidden from user in Vista, adding
an extra level of complication.

Maybe, I don't know, my attempt to place the CAI / dll's in this folder
prior to installation is what's preventing me from installing for a Standard
User, if say the folder has some additional level of security/rights
associated with it.

Any comments or tips appreciated.
Peter T