auto install add-in

F

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!
 
V

Vaughan

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

What version of Excel do you use?
 
F

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.
 
J

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
 
Top