hi guys!

We have developed an Excel Add-in, which works in English and Japanese Excel 2000 on Japanese Windows OS.

However, when we deployed this to the client(which uses a Japanese Excel 2000 on Japanese w2k os) , the XLA wouldn't work. The funny thing is that, the button that we have built with the add-in appeared on the toolbar without much trouble but when the button was click to fire a function that was embedded in the XLA, it wouldn't work as if nothing happened. Worse, no errors appear at all.

Another strange thing is that the said XLA was installed on three different machines in the same company and generated the same results. The macro security set in the excel application was set to medium, which should show a dialogue box that would ask the user if he/she wants to enable or disable macros. BUT, if the button in the XLA worked already, thus, the macro should be able to run the code that is embedded in the XLA also.

Please help, we are so stumped.

Thanks!

Check the simplest things first, and work your way up.

First, check the button - is there a "macro" assigned to it? Does this macro match the name of the function you are trying to launch in your Add-In?

Next, launch VBA. Is the Add-In there? Is all the code there that you expect?

If all that works, place a breakpoint early in the Add-In code, and attempt to run the Add-In again. Was the breakpoint hit? If so, continue tracing through the code to see if it goes down a path you weren't expecting.

I know that this sounds like "make sure it's plugged in" (which, I guess, it is), but from my experience with creating and deploying XLA's, it is usually the simple things that bite you.

Hope this helps.