vba constant value for "Unicode Text" in PasteSpecial function

B

Bourgui

Hi all,

I have a routine in Excel VBA 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 version of office, 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:


ActiveSheet.PasteSpecial vbCFText


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


Thanks!
 

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