Add Ins

User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Add Ins

Post by VegasNath »

In my VBE, I have 2 add-ins showing, ATPVBAEN.XLA & FUNCRES.XLA, but I cannot find where they are located on my vista machine, any ideas?
:wales: Nathan :uk:
There's no place like home.....
Top
User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Re: Add Ins

Post by VegasNath »

I found that these are to do with the Analysis Toolpack add-in. Why do they need to be shown in the project tree, they just add to the clutter!
:wales: Nathan :uk:
There's no place like home.....
Top
User avatar
HansV
Administrator
Posts: 78488
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Add Ins

Post by HansV »

If you tick the check box for Atpvbaen.xls, you can use the functions from the Analysis ToolPak add-in in your VBA code.
Best wishes,
Hans
Top
User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Re: Add Ins

Post by VegasNath »

Thanks Hans.
:wales: Nathan :uk:
There's no place like home.....
Top

Return to “Excel and other spreadsheet applications”