Probably a very simple question...

[SamA]

Hi All,

I'm really not experienced with Macro's at all, but in my current job I've inherited a sheet that has a macro in it. The macro itself works fine when I run it in excel 2007 however when I send it out to people using excel 2003 it won't work and gives the 1004 error. It's saved in the 97-2003 compatible format and I've also tried sending it in the macro enabled format but get the same error every time.

Does this sound like a compatibility problem or a problem with the macro itself? If it's the macro itself I can contact the intern who created it to ask them to correct it but it just seems odd that it works fine in Excel 2007 but not 2003.

Any help would be greatly appreciated.

 

[SamA]

Ah, great, thanks, I'll contact one of the people having trouble with it and ask them!

 

[CharlesChuckieCharles]

It may have something to do with the references in the VBA editor under the TOOLS menu

it probably says Microsoft Excel 12 object Library

when it hits a system with 2003 only it probably disappears as in *Missing*

ask someone to check


This is a case of the developemnt area being ahead of the client which always results in roll out hell

if that is so they (the user ) should uncheck that Missing entry and then select
Microsoft Excel 11 (or 10?) object Library from the list.

Than recompile the vba ( under DEBUG ) save then load as normal to check it works

That same user should then send you back the file to Distribute which you should NOT edit or run or open.