Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vba constant value for "Unicode Text" in PasteSpecial function
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |