language of Office for vba commands

[eran3185]

Hi

I need to use this line of code:
Range("A1").Select
ActiveSheet.PasteSpecial Format:="text", Link:=False, DisplayAsIcon:= False
The problem: When I use another computer with Office in another language (not English) the command is different ("text" in another language) and I get 1004 error.
Is there a way to write the same command that will "fit" any language of Office ?

TNX

 

[steve the fish]

So does that work on your machine? I cant find a pastespecial option to paste as text. Change the cell format to text first then pastespecial values.

 

[eran3185]

A pastespecial option to paste as text - when you want to paste from a webpage

 

[Jaafar Tribak]

Hi

I need to use this line of code:
Range("A1").Select
ActiveSheet.PasteSpecial Format:="text", Link:=False, DisplayAsIcon:= False
The problem: When I use another computer with Office in another language (not English) the command is different ("text" in another language) and I get 1004 error.
Is there a way to write the same command that will "fit" any language of Office ?

TNX

You could find out about the equivalent of the word "text" in the other langauge and replace text with it .

I personally use a French edition of Office and I just replace "text" with "texte"

Also, how about using the PasteSpecial Method of the Range object instead of that of the Worksheet object ... Something like :

Range("A1").PasteSpecial xlPasteAll

This shouldn't paste any color formatting if that's what you are trying to avoid.

 

[eran3185]

Jaafar Tribak - Your code is perfect
TNX