Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel to Word

  1. #1
    Guest

    Default

    I was able to create a macro that can create multiple word documents from a data set in Excel but the Word documents are not formatted as the spreadsheet template is. i.e the word document is not centered on the page and some of the text is too close to the borders of the cell, not like in the excel template sheet. Help with auto formatting the word document after pasting from excel into word.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could you just insert and excel worksheet in your word doc?

  3. #3
    Guest

    Default

    Thanks for the one response, already figured it out. Much simpler than I thought, all I had to do was pastespecial DataType:=wdPasteEnhancedMetafile and it created the word documents ready for printing.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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