Move paragraph of a word document to start of next page through Excel VBA

[Manish84]

Hi Friends,

Is there a way to move paragraph of a word document to start of next page.

I know how to control word document from excel and paste any information from excel to word, but and able to move paragraph to start of next word page. Can anyone you please help me on this.

The same query is also posted in another forum
https://chandoo.org/forum/threads/mo...cel-vba.38172/

Regards

[macropod]

There are various ways, depending on what you want to achieve. For example, a paragraph can be formatted with the 'keep together' attribute to stop it splitting across page breaks. Similarly, a paragraph can be formatted with the 'keep with next' attribute to ensure a heading, for example, remains on the same page as the first paragraph that follows it. These settings can be used together or in isolation. With headings, in particular, the 'keep with next' attribute might be applied to the relevant heading Style so it becomes automatic. If that's not what you want to do, you'll need to provide more information.

[Manish84]

Thank you macropod for your reply,

For easy understanding, i have attached the word document in which the VBA code will run from Excel should run.

Steps which i am following:
Files used:-
a) Excel File - With table to be copied from
b) Word template - Copied table to be pasted (attached with this post "Letter Template). Also for easy understanding i have also attached a word template with the table Name "Letter Template 2"

- The VBA code will run from Excel -> Copy the table from Excel -> paste in Word Doc -> Move the "APPENDIX: DOCUMENT" in word template to start of second page.

The position of "APPENDIX: DOCUMENT" keeps of changing as for some employees tables rows are less or more (number of rows are not constant). hence for each employee's letter position of "APPENDIX: DOCUMENT" changes.

Hence using code i want to move all the text staring from "APPENDIX: DOCUMENT" to second page
I know how to copy paste excel to word document, but not able to move the section as mentioned above to second page. Can you please help me on this,Do let me know if you need any other information.

[macropod]

Instead of using empty paragraphs to try to push the "APPENDIX: DOCUMENT" content down to the second page, insert a manual page break before it in your 'template'. No code required. This is basic document formatting stuff; you should learn how to use Word. As it is, your 'template' isn't a Word template at all (it's a document), you've tried to format it by overriding the format of the 'Normal' Style with whatever takes your fancy instead of creating/using Styles for the job, and the DATE field in the header is liable to update every time the document is opened (if you used a proper Word template with a CREATEDATE field there, that wouldn't be an issue).

[Manish84]

Thanks macropod,

My problem is solved with Page break