Formatting MS Word Footers with VBA -- from Excel

[MacroEcon1337]

I have an excel macro – (not handy at the moment, but can fetch tomorrow AM if needed) – which creates a fresh Word document, and transfers/pastes into it about 50 pages of text/image content from Excel.

But the footers are killing me. What I am looking for is this:



--------------------------------------footer begin below--------------------------------------
<LOGO IMAGE: left justified> <PAGE #: right justified>
--------------------------------------- end footer----------------------------------------------



Can anyone think of a simple code which would create a fresh word document with footers that look like the above?

Notes:

1. I think a 2x1 TABLE may need to be injected into the Footer - otherwise, the Logo Image and Page # both want to JUSTIFY the same direction.

2. Page # needs to be dynamic - like a field code -- that way they update if new pages are inserted into the word document AFTER it has been created.

I worked all afternoon on this, and could not solve. Any suggestions or code greatly appreciated,


MC

 

[Macropod]

If you're doing this often, which seems likely, you should create a Word template with the page layout, including headers & footers, you require. You'd the reference that template when using the .Documents.Add method, obviating the need to create the page layout etc. in code.

As for the justification, you don't need a table, simply use an ordinary paragraph with a right-aligned tab-stop at the right margin and insert a tab character between the logo and the PAGE field.

 

[MacroEcon1337]

The problem is there are sections (spaced at random intervals, depending on the data), for which there are no footers at all.

I realize we could begin with a template (with footers), and then programmatically delete the footers in those sections. But my preference is to build from scratch.

Is this possible, or am i wandering down an alleyway of terrible complexity?

MC

 

[MacroEcon1337]

The tab-stop idea set me on the right path, and I was able to solve. This post was very helpful:

https://stackoverflow.com/questions/37832220/insertalignmenttab-in-footer

EDIT:

PS - thank you!