View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wpreqq99@yahoo.com is offline
external usenet poster
 
Posts: 21
Default Set an Add-In to This Workbook module

I want to make sure that anyone who runs a report will have an Add-in
set to True on their computer before they start.
I tried putting this line in the This Workbook module, but nothing
happens.

Sub AddInsSet()
AddIns.Add("Analysis ToolPak").Installed = True
End Sub

Any suggestions??
Thanks
jeff