excel macro

Posted by Allan on January 11, 2002 8:45 AM

Now working in france they have french macros when i attempt to use them with my excel 2000 uk version the macro come up with an error

Posted by Juan Pablo G. on January 11, 2002 9:11 AM

That shouldn't happen. VBA is in English only, Excel however has different language versions. The only problem i've seen (I work with spanish and english versions) is when working with Data validation and Conditional formatting, or using formulas from the Analysis Toolpak, is this the case ?

Juan Pablo G.

Posted by DK on January 11, 2002 9:27 AM

That's not entirely true. Prior to Excel 97 VBA was programmed in the language of the version in question (e.g. the French version of Excel 5.0 was programmed in French). If the macro was created using one of these versions then an additional file is required for Excel 97-02 to interpret it. Try here:-

http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q176531

HTH,
D.

Posted by Juan Pablo G. on January 11, 2002 9:28 AM

Forgot that, i only use 97, 2000 and XP. So, yes, that's another thing to keep in mind.

Juan Pablo G.