View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Klaus Heinrich Klaus Heinrich is offline
external usenet poster
 
Posts: 7
Default Macros from German excel don't work with English version

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