View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Hall Bill Hall is offline
external usenet poster
 
Posts: 6
Default Installation of "Add-Ins" in code

When my Excel workbook is opened, I want the Excel code to check to see if
the Add-Ins "Analysis Toolpack" is already installed on the user's Excel
application. Because I am using several of the Analysis Toolpack functions
in my worksbook, I need the Add-Inns to be installed. If it isn't installed,
how do I code Excel to automatically install the "Add-Ins" when the workbook
is opened?

Similary, I need the Tools Options Calculation to be on MANUAL for the
workbook to function normally. Am I able to include that in my code?

Thanks in anticipation

Bill Hall