Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Macro to convert multiple RGB colors to Red

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
XGP - 27 Mar 2006 00:06 GMT
I need to convert word documents which have a large part of the text in
multiple custom RGB values to standard red RGB (255, 0, 0). I have already
made some other format changes editing macros but I am an absolute beginner
in VB. Can anyone help me with the VB code?
Signature

XGP

Tony Jollans - 27 Mar 2006 11:18 GMT
Hi XGP,

Potentially very difficult but if all other text in the document is
uncoloured you could do it with three Find and Replace operations like this
...

In all cases leave the Find and Replace text boxes blank.

1. (a) Click in the Find box, click on Format > Font and select Text Colour
"Automatic"

1. (b) Click in the Replace box, click on Format > Font and check "Hidden"
(or some other attribute that no other text in the document has)

1. (c) Replace All

2. (a) Click in the Find box, click on "No Formatting" then click on Format
> Font and UNcheck "Hidden" (or whichever attribute you chose in the
previous operation)

2. (b) Click in the Replace box, click on "No Formatting" then click on
Format > Font and select Text Colour Red

2. (c) Replace All

3. (a) Click in the Find box, click on "No Formatting" then click on Format
> Font and check "Hidden" (or whichever attribute you chose in the first
operation)

3. (b) Click in the Replace box, click on "No Formatting" then click on
Format > Font and UNcheck "Hidden" (or whichever attribute you chose in  the
first operation)

3. (c) Replace All

--
Enjoy,
Tony

> I need to convert word documents which have a large part of the text in
> multiple custom RGB values to standard red RGB (255, 0, 0). I have already
> made some other format changes editing macros but I am an absolute beginner
> in VB. Can anyone help me with the VB code?
> --
> XGP
XGP - 27 Mar 2006 12:05 GMT
Hi Tony,
Very smart and simple solution. It worked. I will now try to write the macro.
Thanks.
Signature

XGP

> Hi XGP,
>
[quoted text clipped - 42 lines]
> > --
> > XGP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.