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

[@arvindkumarauro9731]

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.

[@WiseOwlTutorials]

My pleasure Arvind, glad you enjoyed it!

[@remarcsd]

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

[@WiseOwlTutorials]

Thank you so much!

[@-Meric-]

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

[@WiseOwlTutorials]

Thank you for the lovely comment and for taking the time to write it!

[@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?

[@WiseOwlTutorials]

Thanks Yasser! I'm sorry but I didn't keep the completed code for this example but you can get the starting code from the link in the video description.

[@KhalilYasser]

@@WiseOwlTutorials Thanks a lot, my tutor.

[@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.

[@IndiaDefenceWing]

He is the best person I ever know for VBA knowledge. I always try to consult him first for any issues in VBA.

[@WiseOwlTutorials]

Thank you as always Ravi for your support and comments!

[@WiseOwlTutorials]

@@IndiaDefenceWing Thank you Sunil, I appreciate that!

[@bondniko]

Over 5 bln people have no idea about vba

[@arpitj07_]

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.

[@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. :)

[@WiseOwlTutorials]

😀 well I'm really happy to hear that the videos have helped you in the past! I can't promise a whole series on web development but, just out of curiosity, what language(s) are you developing in?

[@Praguedpaul]

@@WiseOwlTutorials i would highly appreciate if you could do the basics of web development perhaps - like starting with html, css and then into Javascript. I am interested in python too along with AI if you fancy that mate 😬 Point is i still watch your vba videos, and learn few things here and there and also because your videos do much more than solving queries of audience, they create a solid foundation of the subject and this is because of 2 things in my opinion - your articulation is probably the best i came across my life and secondly your attention to details. And i take the pleasure of recommending your channel and videos to those new kids in the programming block. Btw i would love to support you anyway should you choose to put videos on web development. Thanks again mate. Take care.

[@WiseOwlTutorials]

@@Praguedpaul 😀 it might take a while to get all that sorted! We may be able to help you with at least the basics of Python a little sooner though! I really appreciate the generous feedback, as well as the recommendations to others, it means a lot, thank you!

[@Praguedpaul]

@@WiseOwlTutorials can’t wait mate. Thanks 🙏🏻 and the pleasure is all mine btw. @everybody who might be reading this - keep calm, it’s happening 😬

[@alandrewgibson]

Good stuff thanks!

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@purple001100]

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

[@selvan1264]

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 :)

[@WiseOwlTutorials]

Thanks Selva! This link gives some basic information on editing headers and footers learn.microsoft.com/en-us/office/vba/api/word.headersfooters I hope it helps to get you started!

[@selvan1264]

@@WiseOwlTutorials Thank you for the link. Do you know how to insert date, serial code [left align] and the page number [right align] in the footer?

[@WiseOwlTutorials]

@@selvan1264 Hi Selva! You can try this stackoverflow.com/questions/40658599/vba-multiple-footer-and-header-allignment-how-can-i-allgine-left-center-and-ri I hope it helps!

[@selvan1264]

@@WiseOwlTutorials Thank you for the quick reply. May I check how to include page numbers using the format page x of y [right align] and serial number will be [left align]?

[@WiseOwlTutorials]

@@selvan1264 Hi Selva, you can try some of these suggestions for adding page numbers: devblogs.microsoft.com/scripting/how-can-i-add-a-page-x-of-y-footer-to-a-microsoft-word-document/ www.vbaexpress.com/forum/showthread.php?61338-Page-X-of-Y-in-Footer-(Word-2013) stackoverflow.com/questions/63345342/page-footer-page-x-of-y I hope it helps!

[@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?

[@WiseOwlTutorials]

Hi Fabio! You might find this link useful stackoverflow.com/questions/41495416/find-replace-in-a-word-document-footer I hope it helps!

[@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.

[@WiseOwlTutorials]

Hi Sunil, if all you want to do is download a file and you have its URL you can use the URLDownloadToFile function. We have a video on downloading files from websites. If you need to click on drop down lists to get the file URL then you'll need to use a browser as far as I know.

[@IndiaDefenceWing]

Thanks Andrew. Yes, I remember the video about downloading but the issue is I don’t have url as it changes based on selection of options. Radio button and drop down are based on different conditions and very dynamic in nature. Thanks again for reply. I will do my part of research on it.

[@WiseOwlTutorials]

@@IndiaDefenceWing Good luck with it!

[@jessipinkman7659]

Sir, You are god on this earth 🌍!

[@WiseOwlTutorials]

😀 thanks for the high praise!