Easy way to install XLL on client?

[Serge]

I am having a completely unexpected issue with users not knowing how
to install an XLL. I wrote out a 5-step procedure, but users want
something simpler. I'm new to Microsoft, so I don't know what best
practice is. Can I give users an installation file that doesn't
require admin privileges that just copies the XLL into an accessible
directory and loads the XLL into Excel?

Any ideas? Thanks!

[Govert van Drimmelen]

Hi Serge,

Under newer Excel versions the Add-Ins dialog has been hidden away
quite far, so I can image many users don't know how to find it.
Maybe you can check or add the .xll as an Excel add-in in the
AutoOpen, and then just advise the users to File->Open your .xll?

Otherwise, you could make a proper installer for the .xll which
creates the right OPENx registry entries, and does the UAC or admin
prompting etc.

Excel stores the list of enabled add-ins in the Windows registry (key:
HKCU/Software/Microsoft/Office/$version/Excel/Options, values: OPEN,
OPEN1,
OPEN2 etc.). The installer should just add another OPENx.

-Govert

[Govert van Drimmelen]

Alt-t-i is also a great shortcut to open the Excel Add-Ins dialog and
it still works in Excel 2007.