+ Reply to Thread
Results 1 to 2 of 2

Line spacing problem when copying to word

  1. #1
    Valued Forum Contributor
    Join Date
    11-16-2004
    Location
    Devon UK
    MS-Off Ver
    2010
    Posts
    357

    Line spacing problem when copying to word

    I use the code below to copy an invoice from excel to word documents. This works fine is excel 2003 but now I have upgraded to office 2010 the line spacing on the word documend is incorrect (double spaced) can anyone suggest a modification to this code to make it work with 2010?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Line spacing problem when copying to word

    You'd better use the field 'Includetext' in the Word document.
    In this fieldcode you can specify which file, which sheet and which range has to be imported.
    The only thing you have to do is to 'update' the link using Activedocument.fields.update. That's all.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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