Hi Folks

I recently installed an excel add-in application called
Essbase. I manually connect to a server that houses the
data for this add-in. This is done for every worksheet in
the workbook! Is there a way to automate this task via a
macro (such as a call function)?

This ensures the "Analysis ToolPak" add-in is installed ...

AddIns("Analysis ToolPak").Installed = True

.... and this will ensure it's not ...

AddIns("Analysis ToolPak").Installed = False

Change the add-in description as appropriate.
There's more help in Excel's VBA help file

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"McNiwram" wrote in message
...
Hi Folks

I recently installed an excel add-in application called
Essbase. I manually connect to a server that houses the
data for this add-in. This is done for every worksheet in
the workbook! Is there a way to automate this task via a
macro (such as a call function)?

Cheers matey

I'll try your suggestion after the holidays. Too busy now
to test it. I'll post a feedback after testing.