Using a command button to run a data analysis application

D

djf MA

I'm trying to use a macro to automatically run a data analysis (i.e Histogram
on a data set). I get a "Runtime Error 1004". Excel seems to be looking for
the location of "ATPVBAEN.XLA!Histogram. THe code of my macro is as follows:

Sub Macro1()
'
' Macro1 Macro
'

'
Range("A1:A9").Select
Application.Run "ATPVBAEN.XLA!Histogram",
ActiveSheet.Range("$A$1:$A$9"), _
"", , False, False, False, False
End Sub


I was curious how I could overcome this error. Anyone have experience with
this?
 

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

Data Analysis Tool 5
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
Stop Command Question 4
Access toolpak program from Addins 1
Newbie-question: recorded macro does not work - why? 3
Calling Fourier plug-in from VBA 1

Top