vba constant value for "Unicode Text" in PasteSpecial function

[bourgui]

Hi all,

I have a routine that pastes the unicode content of the clipboard on
the active worksheet. The line is simply

ActiveSheet.PasteSpecial "Unicode text"

This works fine on an english system, but not on other languages - the
argument "Unicode Text" must be the translation for that language. The
problem is that I can't find the corresponding vba constant value for
"Unicode Text".

For "Text", it would be 'vbCfText' (= CF_TEXT = 1) for example.

Does anyone know where I can find the corresponding value? I don't
have an Office version of each language that exists! )
I tried looking on MSDN but without joy, ang google hasn't been kind
to me either (

Thanks!

 

[krazymike]

I searched for xlclipboardformat "Unicode Text"

xlUnicodeText 42 Unicode Text

http://msdn.microsoft.com/en-us/library/bb241279.aspx