Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2012, 11:25 AM
blukava blukava is offline Macro for microsoft Word Windows 7 32bit Macro for microsoft Word Office 2003
Novice
Macro for microsoft Word
 
Join Date: May 2012
Posts: 3
blukava is on a distinguished road
Default Macro for microsoft Word

Hello Everyone!



I would like to create macro for converting Cyrillic alphabet to Roman.
Could you please give me any helpful information regarding this?

Thank you in advice.
Reply With Quote
  #2  
Old 05-26-2012, 06:31 PM
macropod's Avatar
macropod macropod is offline Macro for microsoft Word Windows 7 64bit Macro for microsoft Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Given that the two alphabets are rather different, what do you mean when you say you want to convert one to the other?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-26-2012, 06:54 PM
macropod's Avatar
macropod macropod is offline Macro for microsoft Word Windows 7 64bit Macro for microsoft Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: http://www.techsupportforum.com/foru...rd-647440.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-27-2012, 12:58 AM
blukava blukava is offline Macro for microsoft Word Windows 7 32bit Macro for microsoft Word Office 2003
Novice
Macro for microsoft Word
 
Join Date: May 2012
Posts: 3
blukava is on a distinguished road
Default

Hi again,

Yes, they are different.

Is this possible to create macro which will convert Cyrillic to Roman alphabet?

Thanks
Reply With Quote
  #5  
Old 05-27-2012, 01:02 AM
macropod's Avatar
macropod macropod is offline Macro for microsoft Word Windows 7 64bit Macro for microsoft Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

you still haven't answered my question:
Quote:
what do you mean when you say you want to convert one to the other?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 05-27-2012, 05:53 AM
blukava blukava is offline Macro for microsoft Word Windows 7 32bit Macro for microsoft Word Office 2003
Novice
Macro for microsoft Word
 
Join Date: May 2012
Posts: 3
blukava is on a distinguished road
Default

Sorry but it's little bit funny question : )

Text what will be in word document I want to convert to Roman.
This is the reason why I want to create macro which will find Cyrillic alphabet and replace it to Roman.

What's difficult here to understand? : (
Reply With Quote
  #7  
Old 05-27-2012, 06:13 AM
Charles Kenyon Charles Kenyon is online now Macro for microsoft Word Windows Vista Macro for microsoft Word Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

There is not a one-to-one conversion. Letters in the two alphabets do not necessarily have an equivalent in the other, otherwise, you could simply change languages and fonts.
Reply With Quote
  #8  
Old 05-27-2012, 02:43 PM
macropod's Avatar
macropod macropod is offline Macro for microsoft Word Windows 7 64bit Macro for microsoft Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
I want to create macro which will find Cyrillic alphabet and replace it to Roman
OK. At last you've said what it is you want to do.

As there is more than one Cyrillic alphabet (26, actually, see: http://en.wikipedia.org/wiki/Cyrilli...#Summary_table), you'd need to clarify which one you want to convert also. Then there is the problem of what each character should be converted to. For example, I have no idea what 'ж' should be represented as.

According to the 'Romanization' discussion here (http://en.wikipedia.org/wiki/Cyrilli...t#Romanization) there are also at least seven different systems for Romanizing the Cyrillic alphabet. You would have to choose the systme that suits your needs.

If you pick a simple Romanization system, it might require nothing more that a sequential Find/Replace operation in which each Cyrillic character (or a group of Cyrillic chracters) is replaced with one or more Roman characters. If that's all you require, a simple Word table could be used to hold the Find/Replace character list. For that, create a suitable two-column table with the Cyrillic chracters in the first column and the Roman characters in the second, add the following macro to the document, then run it. All you'll need to do is to select the document to process when prompted by the macro.
Code:
Sub Romanize()
Application.ScreenUpdating = True
Dim i As Long, Rng As Range, FRTbl As Table
If Application.Dialogs(wdDialogFileOpen).Show <> -1 Then Exit Sub
If ActiveDocument = ThisDocument Then Exit Sub
Set FRTbl = ThisDocument.Tables(1)
For i = 2 To FRTbl.Rows.Count
  With ActiveDocument.Range.Find
    .ClearFormatting
    Set Rng = FRTbl.Rows(i).Cells(1).Range
    Rng.End = Rng.End - 1
    .Text = Rng.Text
    .Replacement.ClearFormatting
    Set Rng = FRTbl.Rows(i).Cells(2).Range
    Rng.End = Rng.End - 1
    .Replacement.Text = Rng.Text
    .MatchWholeWord = False
    .MatchCase = False
    .Wrap = wdFindStop
    .Execute Replace:=wdReplaceAll
  End With
Next
Set FRTbl = Nothing
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
microsoft word dells2711 Word 4 01-04-2012 10:41 AM
Macro - Microsoft Word 2010 OfficeHelpSG Word 3 10-18-2011 11:54 AM
Macro for microsoft Word drawing in microsoft word 951Michael Drawing and Graphics 1 04-29-2011 10:53 PM
Please help with a macro in Microsoft Word 2007 AKMMS Word VBA 0 06-23-2010 02:16 PM
Microsoft Word 1997 tightline Word 0 08-03-2009 11:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft