Forum Discussion

JoelMG's avatar
JoelMG
Copper Contributor
Nov 27, 2019

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

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

 

 

 

 

Macros and VBA

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 28, 2019
    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.
    • JoelMG's avatar
      JoelMG
      Copper Contributor
      Nov 28, 2019

      Thanks.  Apparently the Analysis Toolpak VBA is not available on the Mac. JKPieterse 

Resources