VBA to Change Clipboard Text Color to Red and Paste Text to Word

[chasoe]

Dear Sirs,

As I need to repetitively coping text strings from PDF and then paste to specific locations in Word document but in red font color.

I'm thinking of creating a macro to change the text color in the Clipboard to red first, and then paste them to Word.
ie
1. Select text string from PDF, Ctrl + C (to copy to Clipboard)
2. Go to Word document, excute the macro for pasting

Grateful if someone could help.

Many thanks.

Edward

 

[rlv01]

You can't manipulate text like that in the clipboard. Changes like that have to be done either before you copy or after you paste.

 

[chasoe]

You can't manipulate text like that in the clipboard. Changes like that have to be done either before you copy or after you paste.

Thanks for your advice, and I've thought out a work around which I would like to share :
(macro will create a new temp Word document, paste the string, select all to change to font color, and copy to required Word in desired place, the temp document will be closed without saving)

Sub PasteSelectionInRed

Dim docA As String
Dim docB As String
Application.ScreenUpdating = False

docA = ActiveDocument.Name
Documents.Add Template:=docB, NewTemplate:=True

docB = ActiveDocument.Name
Selection.PasteSpecial DataType:=wdPasteText

Selection.WholeStory
With Selection.Font
.Name = "Times New Roman"
.Size = 12
.Color = vbRed
End With
Selection.Copy

Documents(docA).Activate
Selection.Paste

Documents(docB).Close SaveChanges:=wdDoNotSaveChanges

Set tmpName = Nothing

Application.ScreenUpdating = True

End Sub

The above codes will be stored in Work's template, with the macro icon stick to the ribbon bar.
When cut is done in PDF, then place cursor to Word document at desired location, and click the macro icon in ribbon, and everything is done.
This macro will save the work of selecting the pasted string in Word and change font color, which will become very tedious if done repeatedly.

Rgds,
Edward