Macros from German excel don't work with English version

[Klaus Heinrich]

Hi folks

I wrote some macros in German version of Excel 2003.
When trying to start them with English version of Excel 2003 ( both on XP )
I receive the following message:

Run-time error '-2147319784 (80028018)
Method 'Activate' of object'_Worksheet' failed

for this line of my coding: ThisWorkbook.Sheets("Artikel").Activate

I searched the web and found some hints about
globalization and localosation of VBA project.
I did not really understand if there is any chance to convert
my German VBA code into an international version.

Any hints on this ?

Thanks in advanced

Klaus

 

[Nigel]

Not sure about the general issue but the specific problem you highlight
suggests that the worksheet named "Artikel" does not exist or it is hidden -
I do not think this is a language version issue?

 

[Klaus Heinrich]

Hi Nigel,

thanks for your reply. It is in fact a language problem.
I created a new sub in the same workbook in English enviroment
with same vba statement and it worked fine.

I allready googled the runtime error, but there were too many
confusing hints that I didn't understand. So I am not sure
what to do or if there is a chance to convert vba.

Thanks

Klaus

 

[Tom Ogilvy]

Check out Stephen Bullen's free chapter on International Issues in Excel:

http://www.oaltd.co.uk/ExcelProgRef/Ch22/ProgRefCh22.htm
International Issues