calling an Excel Add-in application

  • Thread starter Thread starter McNiwram
  • Start date Start date
M

McNiwram

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"
 
Cheers matey

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