I'm emailing a workbook to a group of recipients. The workbook contains cells
that require the Analysis Toolpak add-in. Of course, when I open the workbook
the toolpak is active. How do I program the workbook to automatically
activate the toolpak on other computers when recieved via email?

Thanks for your help!

Hi Dave

Application.AddIns("Analysis ToolPak").Installed = True

Not all users have this Add-in installed and if they use a other language version it will not work
because ATP functions will not translate.

Maybe you can use functions that not use this Add-in


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave" wrote in message ...
I'm emailing a workbook to a group of recipients. The workbook contains cells
that require the Analysis Toolpak add-in. Of course, when I open the workbook
the toolpak is active. How do I program the workbook to automatically
activate the toolpak on other computers when recieved via email?

Thanks for your help!

Dave,

Put this into a workbook open event

AddIns("Analysis ToolPak").Installed = True

[the code is fine even if the toolpak is already installed]

p.s.
got this code by using the recorder...

--
steveB

Remove "AYN" from email to respond
"Dave" wrote in message
...
I'm emailing a workbook to a group of recipients. The workbook contains
cells
that require the Analysis Toolpak add-in. Of course, when I open the
workbook
the toolpak is active. How do I program the workbook to automatically
activate the toolpak on other computers when recieved via email?

Thanks for your help!