Not too big, just wrong file extension.
I was in impression that these codepage issues are part of computing history, but no. [senroded content could be placed here, use creativity]
Frustrating issue anyway.
I really need a decent, proper solution for this cyrillic issue for the 11 INT.
Petri
Macro pasted below, I hope it get through now.
--macro--
Sub encode()
For Each cell In Selection
cell.Value = Replace(cell.Value, ChrW$(1081), "Ć©", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1094), "ƶ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1091), "ó", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1082), "ĆŖ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1077), "Ć„", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1085), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1075), "Ć£", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1096), "Ćø", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1097), "ù", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1079), "Ƨ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1093), "Ƶ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1098), "Ćŗ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1092), "Ć“", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1099), "Ć»", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1074), "Ć¢", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1072), "Ć ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1087), "ĆÆ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1088), "ư", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1086), "Ć®", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1083), "Ć«", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1076), "Ƥ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1078), "Ʀ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1101), "ý", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1103), "Ćæ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1095), "Ć·", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1089), "Ʊ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1084), "Ƭ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1080), "ĆØ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1090), "ò", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1100), "ü", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1073), "Ć”", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1102), "þ", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1049), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1062), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1059), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1050), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1045), "Ć
", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1053), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1043), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1064), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1065), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1047), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1061), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1066), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1060), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1067), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1042), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1040), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1055), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1056), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1054), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1051), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1044), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1046), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1069), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1071), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1063), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1057), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1052), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1048), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1058), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1068), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1041), "Ć", vbTextCompare)
cell.Value = Replace(cell.Value, ChrW$(1070), "Ć", vbTextCompare)
Next cell
End Sub
--macro ends--