PDA

View Full Version : [SOLVED] AddIn Installation



Cyberdude
08-05-2005, 01:10 PM
I hate to admit it, but I can't figure out how to install an AddIn. It all seems to depend on seeing the AddIn's name in the AddIn Manager's dialog box. I've never seen anything in that box ... it's always empty. I downloaded the FindLink AddIn and put it into
C:\Documents and Settings\<my name>\Application Data\Microsoft\AddIns
but now what?? As I said it didn't show up in the AddIn Mgr list. J Walkenbach says to use the Browse button to find it, but there isn't any Browse button. I give up. :banghead:

Ken Puls
08-05-2005, 01:18 PM
Sorry, Sid...

When you go to Tools|Addins, there isn't a Browse button on the right? (3rd down under Okay & Cancel)

Zack Barresse
08-05-2005, 01:19 PM
No Browse button?!?! :eek:

What version are you running? And you are in Tools | Addins, correct??

Aaron Blood
08-05-2005, 01:19 PM
With a blank worksheet open select:

Tools|Addins

...should show a window with a bunch of little addins you can put checkmarks by (while you're in there put a checkmark by Analysis Toolpack, hehehe...)

To the right of the window is a Browse button. That's what J-Walk is referring to.

If you don't see anything in that window and/or no browse button then your cursed IT dept has probably restricted access to it.

Ken Puls
08-05-2005, 01:21 PM
Pic attached from 97. In 2003 there is also an "Automation" button below Browse...

Cyberdude
08-05-2005, 02:33 PM
Sorry, Gang. I thought I was supposed to use the AddIns button on the VBE toolbar. I guess I didn't really realize or expect one to be on the "sheet" Tools. OK, the "sheet" version looks like you describe. Thanks. :doh:

Ken Puls
08-05-2005, 02:35 PM
Ahhh!!

I could be corrected here, but I think that one is for managing COM addins... like MZ Tools.

Cyberdude
08-06-2005, 12:37 PM
I did it! I got FindLink installed. Thanks for all your guidance. :thumb

Ken Puls
08-06-2005, 11:01 PM
Uhh... Findlink is the name of the addin?

Zack Barresse
08-07-2005, 03:49 PM
Yeah, FindLink.xla, by Bob Manville, MS MVP. Generally found/downloaded from Stephen Bullen's website. . . www.oaltd.co.uk/MVP/Default.htm

Cyberdude
08-08-2005, 08:46 PM
I'm disappointed that I can't see the macros in FindLink.xla.
Where can I go to get it?

Bob Phillips
08-09-2005, 12:53 AM
That is proprietary code. Why do you want to?

Cyberdude
08-09-2005, 09:55 AM
Woops! I really didn't think about that. Erase the last question.

Zack Barresse
08-09-2005, 09:59 AM
Hey Sid,

Sorry, won't delete the message, it's good stuff and things everyone should know. You may want to think about putting an email out to Mr. Manville and posing some questions to him. I wouldn't ask him for his [source] code but you might inquire about the methods he used. The worst he can say is no. :)