Font format in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Soniya - 25 Jan 2006 08:15 GMT

Hi All,

I am trying to copy Range A1, C1, D1 to Word Document

I have defined this as X
(like X= A1 & vbcrl & vbcrl & C1 & vbcrl & D1)

How I can apply the same font format in Word too?

In my A1, C1 and D1 often it may contain different font (different
language) based on criteria.

and also Right to left characters.

Thanks

Reply to this Message

NickHK - 25 Jan 2006 08:27 GMT

Soniya,
I'm no Word expert but how about
<PsuedoCode>
Loop
'Copy range("A1")
YourRefToWord.Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF,
Placement:=wdInLine, DisplayAsIcon:=False
'Add the 2 blank line
Do until all ranges complete
</PsuedoCode>

Other methods you get the table with the formatting, which I assume you are
trying to avoid.

Nick

> Hi All,
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Soniya - 25 Jan 2006 09:12 GMT

Thanks for your reply.

How I can do this if I use Table?

Reply to this Message

NickHK - 25 Jan 2006 09:18 GMT

Soniya,
If you want the table, then why not just copy from Excel and paste into Word
?
That way you get everything.

NickHK

> Thanks for your reply.
>
> How I can do this if I use Table?

Reply to this Message

Soniya - 25 Jan 2006 13:01 GMT

No, I want cells to appear in the other way
in Exce it is A, C and D
and in word i want it to be in one column only

Reply to this Message