Comment from Marti Rosas
Time: Monday, June 9, 2008, 10:25 am

Dear Jon,
thank you very much for this esplendid and impressive web site you have created.
It is awesome indeed! I am quite new at excel macros and VBA (after some time dedicated to C++ and other environments), but I have seen that for the students this is an easier way to get into grips with programming. I have discovered the Solver Add-in not so long ago but I have found something weird I think. I follow the instructions that you give at
http://peltiertech.com/Excel/SolverVBA.html
but when you say “[...] In addition, the Solver library will be accessible through the VB Editor’s Object Browser (right), and you will have the benefit of Intellisense (below) while editing code that uses members of the Solver library” , I can see the classes, same as yours, but not the “Members of the VBA-Functions”, i.e. the functions SolverOk, SolverAdd, etc. Do you have any idea why is this so? Thank you very much for your time and congratulations again for the site!
Best wishes from Barcelona (Spain).

Comment from Marti Rosas
Time: Monday, June 9, 2008, 11:39 am

Hi Jon,
that is precisely the problem: when I select the SOLVER library in the top dropdown of the Object Browser it displays the list of the SOLVER classes in the left hand list and I can see the VBA_Functions at the end. But although I select that class, it does NOT show the functions in the list of Members. Consequently VB do not recognize any procedure related to Solver when I call it from a Macro. Nonetheless, I have just discovered something interesting (and even more strange for an absolute begginner like me!). The class Solver4 contains the same members as VBA_Functions though with another name: i.e., SolvAdd, SolvChange, and so on. When I use this “short-named” members, Solver can be called from my macro though when it finishes (after a SolvSolve instruction) there appears a dialog box that begins with
“Cell:[Solver.xla]Ecel4Functions!A1
Formula:
Start of solver cell.
[...]
asking you to continue, to halt, to do it step by step, etc. When I let it to continue and it finishes to calculate, the final Solver dialog box appears (that one with the options of answer, sensitivity, etc. reports) and everything finishes normally.;(
Anyway Jon: I do not want to bother you anymore. If it happens that you encounter the clue, I will be glad and thankfull! I will keep on
investigating what the h*ll is going on and if I find something I will tell you anyay just for you to know!
Thanks very much again for everything and your quick answer!

Pingback from Tidy Up Your Charts « Contextures Blog
Time: Friday, June 20, 2008, 2:21 pm

[...] you can download and install Jon Peltier’s free Align Chart Dimensions utility. There are installation instructions on Jon’s [...]

Comment from Butch Cooper
Time: Sunday, September 14, 2008, 3:09 pm

Not really a comment, but a question.

I have Office 2003 installed and the forms I use for work is in Excel and we added an add-in to update a couple of forms.

When we added the add-in originally, it stay checked. BUT, the last few months, every time we open the form, we MUST go back and make sure the add-in is checked.

It never stays checked.

It USED to, but it no longer does.

Is there an easy way to fix my problem or will I just “ACCIDENTALLY” have to drop my computer in the ocean?

Any help on this would be FANTASTIC!

Comment from Butch Cooper
Time: Monday, September 15, 2008, 2:45 am

So is there a way to go about fixing it, or do I just keep applying the add in every time?

Comment from Rich Gautier
Time: Tuesday, May 5, 2009, 1:18 pm

Hi:
I developed an Add-in (xlam) for Excel 2007 for work that has some custom functions and custom macros. I found how to add custom Ribbon panels for my project, but I’d like the functions I’ve built-in to show up in Intellisense. I was browsing the web and noticed you say your add-in is available through Intellisense. Can you tell me how you exposed your Add-in functions to Intellisense?

Thanks,
Rich

Comment from Igor
Time: Thursday, November 19, 2009, 9:13 pm

Hi,
How can I intercept from Add-In build in event- like FileSave, so I can trigger some custom handling for that event every time for any excel workbook opened

Thanks,

Comment from Igor
Time: Friday, November 20, 2009, 1:40 pm

Thank You Jon,
Looks like it is solution I was looking for

Comment from Jim
Time: Saturday, January 30, 2010, 1:19 pm

Hi Jon, I had an excel guru from work develop a macro file that I add in to co-workers computers. Some of them have Excel 2007 and some have Excel 2003. The macro was created in Excel 2003. He used coding for both versions to make the macro work. I am having one problem with one computer where when trying to use the Tools Add-Ins dialogue box, it won’t recognize the .xla file type and gives me an error. What could be the problem with this one computer?

Comment from Jim
Time: Saturday, January 30, 2010, 4:45 pm

It tells me that .xla is not a valid filetype for excel. I can’t remember the rest of the error message or the number, since it is not my computer that it happens on, I can’t duplicate it at this time.

Comment from Jim
Time: Sunday, January 31, 2010, 2:31 am

it was excel 2003 and only one istance of 2003. other computers with 2003 can rou the macro. he even has another .xla on the same machine.

Comment from Michael Kerner
Time: Monday, March 8, 2010, 8:02 pm

Hello,

I’m in need of a radar graph utility / add-in for excel which allows to define the scale of each leg of the axes indepentently

I tried to install the custom radar chart add-in from http://www.tushar-mehta.com, but it does not work

I use excel 2003 prof sp 2 with windows xp sp3

Comment from Shawn Mitchell
Time: Thursday, March 18, 2010, 5:08 pm

Hi Jon,

Great blog! I am having a tough time with an Excel add-in and I’m not sure how you might be able to figure it out based on the information I have available, but I am going to give it a try.

I got a text book that came with a CD that contained an Excel add-in, which I installed (Excel 2007, just as you described). The book makes reference to a number of custom excel functions (OV_IR_FIXEDYIELD_DATE_YLD, etc.) and I figured that once I had installed the add-in I could just click on a cell and type =OV and I’d see the whole list of new functions, but I get nothing. And when I type in the whole function with arguments and hit enter I get a #NAME? error.

Like I said, not a lot to go on, but if you have any thoughts I love to hear them.

Thanks,

Shawn

Comment from Shawn Mitchell
Time: Friday, March 19, 2010, 9:39 am

Hey Jon, thanks for the quick reply (although I requested email notification and did not receive it).

Here’s what I found.

I’m running excel2007 and the add-in was written for excel2003. The default installation directory was …office11library and not office12library. The office11library directory was not permissioned by default to run add-in’s on my install, so I had to add a Trusted Location in the Trust Center and even then I’m guessing because of some difference between 2003 and 2007 the auto-complete wasn’t working so I had to go to Insert Function and select User Defined, which is a major drag.

Do you have any tricks for getting auto-complete to work on user defined functions so I can just start typing the function name (after an = of course) and have a list of matching functions pop up?

Shawn

Comment from Anonymous
Time: Sunday, June 6, 2010, 2:30 pm

I have installed your LOESS add in, but am having trouble actually using it, how do I get to the above screens you have mentiond.

Thanks in advance

Rhodri

Comment from katherine
Time: Wednesday, July 21, 2010, 10:23 am

Jon,

I am new to excell as well — and am trying to use your LOESS add-in. I installed it and found it in my list of add-ins …. but … as silly a question as this is — I can’t figure out how access it — say get to the dialog boxes you made and everything… if I got to the VBA interface – how do I implement it? –maybe just a couple hints to get started, and then I can figure the rest out? Thanks!!

Comment from naveen
Time: Thursday, July 29, 2010, 12:15 pm

Great info in your blog. I have been looking for the intellisense answer forevevr.

A follow up to the intellisense question. It is best explained through an example. Say I create test1.xlsm with a Function myAdd(). Now I save this as an add-in as test1.xlam I also change the vbproject to TestProject and name the add-in Test Addin. Test Addin shows up in the add-in list, I enable it but myAdd does not show up in subsequently opened new workbooks.

Going back to your response, are you suggesting I try to reopen test1.xlsm and include a reference to “Test Addin” (Which in this case will be itself?) Then resave it as test1.xlam. Will I then be able to see myAdd() in the intellisense list of functions when I type =myA ?

Thanks much

Pingback from Links: Como instalar un Add in (Complemento) de Excel « Optimización y Estadística (SOE SC)
Time: Thursday, August 12, 2010, 10:28 am

[...] Installing an Excel Add-In [...]

Comment from Mike
Time: Tuesday, August 17, 2010, 4:29 pm

I have created an excel add-in with multiple UDF and would like to deploy it to multiple users. However, when a UDF is used in a spreadsheet it hard wires the add-in functions file location so when another uses opens the file they get a #NAME? unless the file is installed in the exact same directory structure. Is there a way around this?

Thanks.