funcres(funcres.xla)

[Guest]

Hi Group,

I have a module that was created in XL2000, which has been upgraded to 2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If i click
on the + to expand it, I am asked for a password. There is not password and I
do not know what this represents. Can anyone point me in the right direction
to figure this out?

 

[Dave Peterson]

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

 

[Guest]

Why am I getting the possible access and the need for a password?

 

[Tom Ogilvy]

The analysis toolpak is furnished as part of Excel. It is password
protected because its functionality is provided, not its code. (however,
most of the code is in compiled dll's anyway - so there isn't much to see).
Additionally, if you were permitted inside and changed things so it wouldn't
work, then that would be a problem.

--
Regards,
Tom Ogilvy

Why am I getting the possible access and the need for a password?

 

[Guest]

It does not serve a purpose in the VBA area. When i look at the add-ins would
i want to toggle the analysis-pak off? I use the analysis functions in my
worksheets for sure. But I am only assuiming that I might use it in VBA.

In the end this is just curious and I am glad to know what the funcres.xla
is and why I was not able or allowed to access it. Thank you for the
information.

 

[Dave Peterson]

If you use the functions in the analysis toolpak in your workbook, then you'd
want to keep it turned on.

Just because it shows up in the VBE's project explorer doesn't mean that it has
to be used in your code.

In fact, you'll see all your workbooks that are open in that project
explorer--whether or not they have any code in them--or you use them in any
other code.

There is another addin named: Analysis TookPak - VBA
That you can turn off (via tools|addins in excel) if you never use it in code.

It does not serve a purpose in the VBA area. When i look at the add-ins would
i want to toggle the analysis-pak off? I use the analysis functions in my
worksheets for sure. But I am only assuiming that I might use it in VBA.

In the end this is just curious and I am glad to know what the funcres.xla
is and why I was not able or allowed to access it. Thank you for the
information.