These functions can be called in exactly the same way as the regular worksheet functions. If you are using Excel 2003, change the filename to "atpvbaen.xla". Application.Run "atpvbaen.xlam!Histogram", _ You can use the macro recorder to help pass in the correct parameters. This add-in actually just provides the interface for the "ANALY32.XLL" file and both these files can be found in the following folders:Įxcel 365 - C:\Program Files\Microsoft Office\Office16\Library\Analysis\Įxcel 2021 - C:\Program Files\Microsoft Office\Office16\Library\Analysis\Įxcel 2019 - C:\Program Files\Microsoft Office\Office16\Library\Analysis\Įxcel 2016 - C:\Program Files\Microsoft Office\Office15\Library\Analysis\ When the "Analysis-ToolPak - VBA" add-in is installed you will see an additional project in your project window called "ATPVBAEN.XLAM". You will receive a "Type Mismatch" error otherwise. You must also have the "Analysis-ToolPak" add-in installed in order for this to work.
You must have the "Analysis-ToolPak - VBA" add-in installed if you want to use any of the extra worksheet functions from your VBA code. When the "Analysis-ToolPak" add-in is installed you will see an additional project in your project window called "FUNCRES.XLAM".
0 kommentar(er)
