In Project Window of VBE

[JMay]

Over the years or during installation (I don't know which?) but when I go
into my VBE I notice 2 Projects (nodes);
1) atpvbean.xls (ATPVBEAN.XLA) and
2) funcres (FUNCRES.XLA)
Are these files Vital? or are they optional?
Both are password protected..
If I were to later rid them from my system it appears the only way to do so
is
to just delete the *.xla files (where I can see their full path in under
Tools, References although Unchecked at the time)...
TIA,

 

[Chip Pearson]

The APTVBAEN is the add-in required to use Analysis ToolPack functions in
VBA. FUNCRES is the Analysis Tool Pak. Don't delete them.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Ken Wright]

They are addins that will get loaded if you enable the Analysis Toolpak (incl
the VBA addin). Funcres is the regular one, whilst aptvbean is the vba addin.
If you have never used these, then you are missing out on a lot of functionality
contained within the addin. If you don't know it's there then you probably
don't miss it, but I personally wouldn't want to give it up. I thought that
Norman Harker actually published a list of all the functions somewhere that you
got from that addin, but I can't find it, so may be mistaken.

 

[J.E. McGimpsey]

The files are optional - both are loaded when the Analysis Toolpak
Add-in (VBA) [atpvbaen.xla] is loaded.

If you don't have a workbook installing the addins in code, then in
XL, choose Tools/Addins and uncheck the ATP (VBA) checkbox.