Wise Owl Answers - How do I create a header with a logo in Word using VBA?

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

Learn how to use VBA in Excel to create a Word document with a page header and how to insert an image into the header. You'll see how to create different headers for odd and even pages and for the first page in the document.

Chapters
00:00 Topic list
01:14 Adding a Simple Text Header
03:58 Formatting the Header Text
05:24 Different Headers for Odd and Even Pages
07:30 Changing the Header on the First Page
09:56 Inserting a Picture into a Header
12:14 Resizing the Picture
13:22 Adding an Image to the Even Numbered Pages
15:07 Aligning the Picture to the Right Hand Margin

[arvindkumarauro]

First of all I want say thank you again to addressing my question and creating a vdo to make me understand and resolve my query. Thanks a ton..!!!🙏🙏❤️❤️ I love ur each and every videos. Ur videos help us to update and improve our skills and knowledge about VBA.

[remarcsd]

Once again your clarity is outstanding. By far the most comprehensive and useful VBA tutorials I have come across.

[-Meric-]

Just wanted to let you know how thankful I am for your content and how helpful it has been. Astounding quality of work <3

[tejamarneni]

Thank you Andrew for such amazing series. Lot of people don't realize the potential of VBA. For Microsoft office tools VBA is still the best. Even though Python and Typescript are trying to catch up but I feel that VBA still has its merits.

[Praguedpaul]

Andrew - this note is just to let you know how you have helped me immensely in my career path. It was 7 or 8 years back when i first started with Vba and your videos were the automatic choice for learning resources. I am grateful for that and can’t thank you enough.
But on the other hand you have spoiled me to the core - over time i try to upgrade my portfolio with new skills and i get disappointed with all the other learning resources as you have set the bar way too high. Mate you better put some videos on web development please from scratch. :)

[KhalilYasser]

The best VBA youtube channel I have ever seen. Thanks a lot, my tutor. Can you post the final file with the final code?

[arpitj_]

Thanks a ton. This was much needed but I also want to know how to add a rectangle shape filled with a color and text over it in the footer. Then add page number.

[purple]

How do create a header with logo, string format and table in Word using VBA ?

[selvan]

This video is excellent! May I check how to include the header with multiple text [date on the left align, logo image in the center and serial number on the left align] or if we have a template how to replace the text in the header? Thank you for the help :)

[FabioWesen]

I would like to thank you for the excellent video. I need help with a HeaderFooter function. I already have a formatted Footer, I would like to get the text and replace it with the content of an excel cell, how can I select only the footer text and replace it using VBA?

[IndiaDefenceWing]

Thanks Andrew. Great as always.

I want to check regarding one query. I have to click on multiple options and select drop down on web page and then have to download a file from another page on same website. Is it possible using XMLHttp60 library. I don’t want to use IE due to time constraints. I have watched your series long back on websites and I don’t remember any such scenario. Is it possible, if yes please guide. Thanks in advance.