|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Header and footer in word document based upon company selected in excel.
Dear All,
Request your help with the scenario. I would need help in changing the header and footer in word document based upon the company selected in the excel (Cell-B9).Can you please assist with VBA code which will help achieve it. Company MAX LTD I am attaching the word and excel documents. Thankyou in Advance! |
#2
|
||||
|
||||
Change the document to a merge document and make the worksheet merge compatible. Merge to a new document. See attached.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thankyou Graham
This solutions provided by you worked wonders. |
#4
|
|||
|
|||
Hi Graham,
Need your expertise on more thing,whenever i convert the template from word to pdf the format changes(eg.lines in bold is change to light font when converted to pdf) Please assist. Thanking you in advance Shomik |
#5
|
||||
|
||||
PDF attributes can appear to change when not viewed at 100% magnification. Are you sure this isn't the issue? Otherwise how are you creating the PDF?
You might find the PDF option in E-Mail Merge Add-in useful.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy a selected range of a document to a new document with preserving formatting,header and footer | RobertDany | Word VBA | 10 | 08-10-2021 04:04 AM |
Adding text to the header and footer without removing all other content in the header and footer | digitalelise | Word VBA | 2 | 10-23-2019 02:58 AM |
Dynamic Header / Footer for ALL documents | Abri | Word | 3 | 08-13-2015 04:40 AM |
Dynamic Dashboard on company intranet | LabProARW | Excel Programming | 0 | 12-16-2014 07:46 AM |
Need help creating a Word document that is populated based on certain selected values | alidaanish | Word | 1 | 01-10-2014 10:44 PM |