LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 419
Default Error when adding a reference to Analysis Toolpak

For anyone who is interested,

I found out what the problem is.

I was trying to add this reference to a file that had code in the
Workbook_Open() event. When I was opening this workbook, I was clicking
"Disable Macros" on the Security Warning message because I didn't want the
code to run. Apparently the VBA IDE won't let you add a library reference
(to the add-ins) when macros are disabled.

I wish the error message had more information.

I hope this helps other people,

Conan


"Conan Kelly" wrote in message
...
Hello all,

I'm getting a generic error message when I try to add a reference to
atpvbaen.xls:

http://home.att.net/~ctbarbarin/vba_...ence_error.jpg

When I click the help button, help opens up with a completely blank
window. I don't know if it is locked up or the specific help files aren't
intalled or something else.

Anyone have any idea as to what might be going on here?

Thanks for any help anyone can provide,

Conan Kelly





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Analysis ToolPak Regression Analysis Help Requested MH Excel Worksheet Functions 1 February 28th 09 07:16 AM
Analysis Toolpak-Confidence Level and data analysis questions MH Excel Worksheet Functions 0 January 3rd 09 06:15 PM
Reference to analysis toolpak addin Snowsride Excel Programming 2 February 10th 05 08:43 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM
"Reference is not valid" error when using analysis toolpak in an add-in tom[_5_] Excel Programming 0 January 16th 04 05:24 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"