atpvbaen link
"Dave Peterson" wrote in message
...
atpvbaen.xla is the VBA version of the analysis toolpak.
There's another addin (Funcres.xla) that will appear when you check the
analysis
toolpak (not the VBA item) in Tools|Addins.
These are guesses, so they might not work.
First, open your workbook with the links to the atpvbaen.xla file. Then
go into
the VBE.
Hit F4 to see the project explorer
select your project
Then click Tools|References
and look for a check mark in front of atpvbaen.xla
and uncheck it.
Then back to excel and save this workbook
and close it and reopen to see if that fixed it.
Creating a reference (in the VBE) to atpvbaen.xla means that your code can
call
all the functions that are in that addin--just like they were built into
VBA.
But if your code doesn't use these, you don't need the reference.
But if your code does use any of these,
double check that tools|addins Analysis Pak - VBA
is checked.
Dean wrote:
I feel like I figured this out when I last saw it about 2 years ago, but
can't recall the answer:
When I open my workbook today, I get an update links query. When I go to
edit links it says the problem is atpvbaen.xla. I seem to recall this is
some sort of add in, but it shouldn't appear to be a link, I don't think.
What is causing this and how do I remove it?
It seems like it's caused by a new worksheet that has eomonth functions
which are an add-in. However, I already used this same function in other
old sheets and didn't have the problem (at least not in a couple of years
of
my memory)!!
Thanks!
Dean
--
Dave Peterson
|