Nov 27 2019 09:34 PM
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
Nov 28 2019 02:01 AM
Nov 28 2019 04:20 AM
Thanks. Apparently the Analysis Toolpak VBA is not available on the Mac. @Jan Karel Pieterse