Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 07-03-2022, 04:46 PM
Guessed's Avatar
Guessed Guessed is offline VBA code to export data to word with header values Windows 10 VBA code to export data to word with header values Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You should do this by using a paragraph attribute in Word.

Go to the Word document and put your cursor in the first cell of the first table. Then via the Home Tab, open the Paragraph dialog and set the paragraph to have a Page Break Before. Once this is done, the macro will reproduce this across all your created tables.

Ideally, you would use styles to be as efficient as possible. You shouldn't put this setting on subsequent rows in the table, just the first row.
Attached Images
File Type: png 2022-07-04_9-37-43.png (21.1 KB, 25 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to export data to word with header values Export data to word table Dzib Excel Programming 7 08-28-2019 11:51 PM
VBA code to export data to word with header values Export Access report as pdf -- save as .rft -- and Word puts some text into the header louiseword Word 1 11-21-2016 04:32 PM
VBA code to export data to word with header values VBA Export Data as Text from Excel to Word lwbarnes Word VBA 3 06-09-2016 02:47 PM
VBA code to export data to word with header values need vba code export data to closed workbook sheets manilara Excel Programming 1 02-12-2016 08:20 PM
VBA code to export data to word with header values Export Word Form Data to Access pboland Word VBA 1 06-12-2015 06:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 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