XLA Add-In Error

**celestialspring** · 12-30-2007, 07:05 AM

Hi guys,

A friend of mine sent me an XLA add-in. The add-in works fine for him but when I try to use it on my machine it gives me an error (see screenshot). He uses Excel 2003 while our office uses Excel 2007. Both OS are WinXP SP 2.

What can I do to get the add-in work for me.

Thanks in advance.

Regards, cs

**royUK** · 12-30-2007, 07:48 AM

I can't read the error messages. However, addins ifrom earlier versions of Excel are usually available in the Addins Tab of 2007's Ribbon.

It depends are the macro code, but I have found it much better to create Excel 2007 versions of my addins by customising the Ribbon & checking that all he code is compatible with 2007.

You could attach the addin by zipping it if you want someone to take a look at it.

**celestialspring** · 12-31-2007, 03:11 AM

Thanks Roy. It won't be possible to share it because of company policy.

regards, cs

**royUK** · 12-31-2007, 04:47 AM

As I said, the images aren't readable on my screen, so you can try attaching downloadable images.

**Richard Schollar** · 12-31-2007, 05:28 AM

Adding to what Roy said, I would check what external libraries are referenced by the Add-In (in xl 2003) and ensure that all are present and available in xl2007.

Richard

**celestialspring** · 12-31-2007, 08:00 PM

Originally Posted by RichardSchollar

Adding to what Roy said, I would check what external libraries are referenced by the Add-In (in xl 2003) and ensure that all are present and available in xl2007.

Richard

Thanks to both of you.

@Richard: How do I do that?

@Roy: I have uploaded the errors here:

[img=http://img120.imageshack.us/img120/5792/error1cv3.th.jpg]

[img=http://img339.imageshack.us/img339/3051/error2rf8.th.jpg]

**royUK** · 01-01-2008, 04:57 AM

To check the references open the VB Editor and in the Tools menu select References, missing ones should be listed.

Looking at the error mssages, it says that a component is missing, possibly a DatePicker? However, that should not cause the problem that removes the VBA project. I wouls suggest that if you want to use the addin then you need it checking & converting to 2007 format.