Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-12-2018, 06:18 PM
Sarah123 Sarah123 is offline Add, Resize & Relocate Header & Footer with Macros Windows 10 Add, Resize & Relocate Header & Footer with Macros Office 2016
Novice
Add, Resize & Relocate Header & Footer with Macros
 
Join Date: Nov 2018
Posts: 9
Sarah123 is on a distinguished road
Default Add, Resize & Relocate Header & Footer with Macros

Hi,



We have a large volume of templates that need to be formatted for print & electronic distribution. Print needs to be blank so it can be printed on pre-printed letter head. For electronic distribution, I want to add a macro button in to insert our company header and footer. I have the below to bring the pictures through, but I have no idea how to resize and relocate into the correct position. Any ideas would be greatly appreciated!


Sub AddImageToHeader()

Dim SrcePath As String

SrcePath = "S:\DocBase\Document Templates\Macros\New Macros Nov 2018\Letterhead.jpg"

ThisDocument.Sections.Item(1).Headers(wdHeaderFoot erPrimary) _
.Range.InlineShapes.AddPicture (SrcePath)

End Sub

Sub AddImageToFooter()

Dim SrcePath As String

SrcePath = "S:\DocBase\Document Templates\Macros\New Macros Nov 2018\Footer Pg1.jpg"

ThisDocument.Sections.Item(1).Footers(wdHeaderFoot erPrimary) _
.Range.InlineShapes.AddPicture (SrcePath)

End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Header and Footer Diablodvs7 Word 1 07-28-2015 07:54 PM
Header and footer aligned in the footer area ashiqghfr Word 2 07-23-2015 01:14 AM
Add, Resize & Relocate Header & Footer with Macros header footer Pierre-Hugues Word VBA 1 08-30-2013 06:06 AM
How to resize the image in the header so that it fits the page Isadora Excel 1 08-20-2013 06:02 AM
Relocate footnotes to facing page Wydeye Word 0 02-23-2010 05:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft