Access toolpak program from Addins

G

Guest

I am trying to access Histogram analysis functionality from Data Analysis
addin from within VBA but it couldn't find the macro even when I point it to
the folder where the file ATPVBAEN.XLA resides. I originally recorded the
statement as a macro and edit the program from there. The following statement
does not work in VBA.

Application.Run "ATPVBAEN.XLA!Histogram",
ActiveSheet.Range("$B$11:$B$178") _
, ActiveSheet.Range("$G$3"), ActiveSheet.Range("$A$11:$A$19"),
False, True _
, True, False

Any suggestion?
 
N

Nigel

You need to load the addin named 'Analysis ToolPack - VBA' to run the
procedures in VBA code.

Your code should run OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to sequence ("$A:$A") to ("$IV:$IV") 15
MS EXCEL - To supress warning messages created by Anlysis ToolPak 1
find name of a chart 5
Calling Fourier plug-in from VBA 1
Code to create a Histogram 5
Newbie-question: recorded macro does not work - why? 3
Data Analysis Tool 5
Analysis Tookpak usage in script 2

Top