Page Header...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Berny - 20 Mar 2006 08:26 GMT

Hi folks,

Can you help me with next problem ?
I am inserting text from Excel into Word using the generic line:

oWordApp.Selection.TypeText Text:="Bla..Bla..Bla..."

The problem is that the text does enter also in the page header. What
do I have to do to avoid this ? Any suggestions are welcome.

Best regards,
Bernard

Reply to this Message

Stefan Blom - 20 Mar 2006 11:47 GMT

The following is one way to make sure that the text is inserted in
the main body of the active document:

oWordApp.ActiveDocument.Content.InsertAfter "Text here."

Most likely, you'd get a more knowledgeable reply in a VBA newsgroup,
though.

Signature

Stefan Blom
Microsoft Word MVP

> Hi folks,
>
[quoted text clipped - 8 lines]
> Best regards,
> Bernard

Reply to this Message

Berny - 20 Mar 2006 12:06 GMT

Hi Stefan,

I found the problem. There was a rectangle object inserted in the
header that had it's text wrapping style wrongly selected. I changed
the style to be <In line with text> and the problem was solved.
Thanks anyway for your suggestion.

Best regards,
Bernard

Reply to this Message

Stefan Blom - 20 Mar 2006 12:33 GMT

I'm glad you found a solution (though I have to admit I'm curious to
find out how/why it helped).

Signature

Stefan Blom
Microsoft Word MVP

> Hi Stefan,
>
[quoted text clipped - 5 lines]
> Best regards,
> Bernard

Reply to this Message