auto install add-in

[Francis]

Hi All,

What VBA code should i write if i want to auto install add-in when opening a xls file?
Because, without installing the "Analysis ToolPak" Add-in, the function "eomonth" from my workbook does not work in the receivers.

Pls help! and thanks a lot!

 

[Vaughan]

Funny, it always installs for me, just by leaving the box ticked in Tools / Add-ins

What version of Excel do you use?

 

[Francis]

Hi Vaughan,

Excel XP. but it is not default in my office, so have to make sure the receivers can read my file pls help.

 

[jconra]

Hi Francis,

Please do keep in mind that when you distribute your file even with th
macro to autoinstall AddInns, if the receiver just has a standard Exce
version installed, the Macro will fail and the user will see an erro
message (error 1004). This problem can only be solved by installing al
of Excel's extras with the Office CDR.

Kind regards and good luck,

Jconra
Netherland