Analysis Tookpak usage in script

[mark]

I loaded the Analysis toolpak add-in.
I recorded use of it's statistical sample.

I try to use the recorded script, it tells me:

'ATPVBAEN.XLA could not be found.'

How do I reference an add-in in a script for use?


************
AddIns("Analysis ToolPak").Installed = True
Application.Run "ATPVBAEN.XLA!Sample",
ActiveSheet.Range("$A$1:$A$19"), _
"Harold", "R", 10, True
***********


I can do what the sample add-in does on my own, if I need
to, but it seemed it was already done.

 

[Tom Ogilvy]

ATPVBAEN.xla is not the analysis toolpak. It is the Analysis Toolpak -
VBA. You need to install that as well.

This contains the VBA usable/callable functions from the analysis toolpak.

 

[mark]

Got it.

Thanks Tom.