Macros from German excel don't work with English version

K

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
 
N

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?
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top