Header when creating report from Excel to Word

Hi I Have this code which creates a header in Word from Excel.

it looks like this:

Please Login or Register  to view this content.

But an error occurs on the last row Selection.ParagraphFormat.Alignment = wdAlignParagraphJustify

What I want to create with that row is that I want the header to be nice centerd.

Here are the screen shots demonstrating the issue.

This is how it is using the code. ( not what I want )

Picture 1.jpg


and this is how I want it to look

Picture 2.png



I would appreciate the help!

You have to add the wdApp else Excel thinks you're refering to Excel Selection.

I think you need a right alignment, not a Justify.

Go to the Word program, load the document, then turn on Show All Formatting Marks and see if there are any tabs embedded in the correct version.

File-> Options>Display>Show All Formatting Marks

If this doesn't work, I'll need a sample Excel/Word documents.

I think I've got it.

You'll never get the format correct by building strings of characters in Excel and pasting them to Word. RESISTANCE IS FUTILE!

So, I've added a table in the header so that normal paragraph formatting can be added.

Please Login or Register  to view this content.

Since we're not using Selection, you can even comment this out.

Please Login or Register  to view this content.

I actually forgot to remove it earlier.

No need to make sheet visible, so...

Please Login or Register  to view this content.

As far as the table width is concerned, if it continues to be a problem, you'll have to set columns widths in the table. Which might prove a challenge since you're copy & pasting the range from Excel to Word.

It doesn't exceed the width on my machine.

Try changing this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.