+ Reply to Thread
Results 1 to 8 of 8

Modify table formatting to word export

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    09-18-2023
    Location
    Geogia, USA
    MS-Off Ver
    365
    Posts
    314

    Re: Modify table formatting to word export

    This is all about how the Word document is formatted and doesn't have anything to do with the code that inserts the paragraphs. Look at the template that is used and the page layout settings for the disclaimer page, the spacing before and after paragraphs, which are set very large. If you would like the alignment of the page to be more to the top, then change the section:

            Set mySect = .Sections(.Sections.Count)
            'mySect.PageSetup.VerticalAlignment = 3      'wdAlignVerticalBottom = 3
            mySect.PageSetup.VerticalAlignment = 0      'wdAlignVerticalTop = 0
    This just tells Word to bottom justify the contents of the page, I switched it to top justification just for testing. I think you just want to modify the spacing which is handled in the Word template.

  2. #2
    Registered User
    Join Date
    11-01-2023
    Location
    Newcastle, Australia
    MS-Off Ver
    2310
    Posts
    4

    Re: Modify table formatting to word export

    Thanks for that, I do want to keep it bottom justified, my main issue is having the first section of each paragraph bolded, which is why I was trying to use a table so I could seperate the parts I want to be bold. I'll attach the page as I want it to look but I've just done it in Word myself.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Export Excel table with formatting to MS Word
    By JaffarAhamed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2023, 12:44 PM
  2. VBA Excel to Word Export Formatting Issue
    By CrazyToucan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2023, 09:14 PM
  3. Replies: 4
    Last Post: 07-14-2022, 02:03 AM
  4. Replies: 3
    Last Post: 07-14-2022, 02:01 AM
  5. How to export to existing Word bookmark AND set formatting
    By jontherev in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2022, 05:09 PM
  6. How do I export an Excel worksheet to Word with some specific formatting?
    By jasonfromchico in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2015, 04:26 PM
  7. How to export table from Excel to WORD?
    By boroangel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2005, 03:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1