Where is the file: ATPVBAEN.XLAM on my Mac?

[JoelMG]

I'm trying to use VBA to automate histogram creation.  I'm using Excel 2019 on a Mac and have the data analysis toolkit installed and working.

I wrote the simplest of programs:

Sub tryHisto()

Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range( _

"$A$2:$A$12"), ActiveSheet.Range( _

"$F2"), ActiveSheet.Range( _

"$C$2:$C$12"), False, False, False, False

End Sub

It does not run.  The error message is, paraphrasing, "can't find ATPVBAEN.XLAM on your computer."  I cannot locate this file on my computer if I search for it (but it must be there as I can use the GUI to create a histogram).  And I can't find the website to download a copy of it so I can place it where the software is looking..

Any suggestions?  Thanks.

Joel

[#2]

The add-in you refer to is a separate one from the Analisys Toolpak. Does your add-ins dialog contain this entry: "Analisys Toolpak - VBA"? If so, check it and you should be good to go. If not, I'm not sure whether this add-in is part of a Mac Office installation.

[#3]

Thanks.  Apparently the Analysis Toolpak VBA is not available on the Mac. @Jan Karel Pieterse