PDA

View Full Version : Excel 2007 and ATPVBAEN.xla (Phffft!)



Cyberdude
01-06-2010, 08:26 PM
I've found that just about every Excel system I've written no longer works because I get an error message that says VBA can't find ATPVBAEN.xla. If it's so important why doesn't MS include it in Excel 2007?? Functions like "DATE" and "CHR" and "LEFT" can't be found by VBA. Yes, I've tried to do a search for it, but SEARCH in Windows 7 just never seems to find what I'm looking for. So I'm asking you guys if you know how I can get a copy of ATPVBAEN.xla? :banghead:

rbrhodes
01-06-2010, 08:38 PM
Hi Cd,

The file you're looking for is listed under Add-ins as 'Analysis Toolpak'. It is included in 2007 but click the 'Office button' then Addins then Excel addins and make sure it is checked. Othere than that there is a trhread here that may help...

http://forums.palisade.com/ShowPost.aspx?PostID=687

See post #4 for a possible solution.

Bob Phillips
01-07-2010, 01:46 AM
Just uncheck the reference, it is built-in to Excel 2007.