Runtime error 1004 when trying to use histogram from Excel add-in

[WaqasTariq]

Hi,
I am trying to make use of the histogram add-in in a macro but it errors out saying "Run-time error '1004':", here is the code.

Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range("B2:B17") _
, ActiveSheet.Range("I1"), ActiveSheet.Range("E1:E24"), False, False _
, False, False

I found a fix for this on MS site, but that too errors out saying the same.

Application.Run "'Analysis Toolpak - VBA'!Histogram", _
ActiveSheet.Range("B2:B17"), ActiveSheet.Range("I1"), _
, ActiveSheet.Range("E1:E24"), False, False, False, False

I have enabled the Analysis tool pack.

Any help will be more than appreciated!

 

[WaqasTariq]

Problem solved.
I needed to add "atpvbaen.xls" as reference in VBA