Analysis Toolpak

[News]

Ive written a spreadsheet that utilises a workday function through the
analysis toolpak add in. As the spreadsheet is to be distributed to users I
have no way of turning the Analysis toolpak on automatically when they enter
the worksheet. Can this be done thought a Macro?

thanks

 

[Gord Dibben]

News

Can be done programmatically(VBA Function) when workbook is opened. See code
here.......

http://msdn.microsoft.com/library/d...en-us/modcore/html/deovrloadingexceladdin.asp

Watch for line-wrap. URL is one line.

Gord Dibben XL2002

 

[David J. Braden]

You could follow Gordon's suggestion, of course, but for whatever
reason, many folks don't have the ATP installed. How about just
replicating the function in VBA using Excel's built-in functions?

Dave Braden

 

[Kent Schederin]

Hi

Put this code in your workbook module

Private Sub Workbook_Open()
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub

Kent Schederin

 

[News]

Perfect

Many Thanks
Mark

Hi

Put this code in your workbook module

Private Sub Workbook_Open()
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub

Kent Schederin

users