+ Reply to Thread
Results 1 to 3 of 3

Copying Excel Data to Word

  1. #1
    Forum Contributor
    Join Date
    10-10-2008
    Location
    western hemisphere
    Posts
    126

    Copying Excel Data to Word

    I have data in Column J1:J90, I use a macro to open
    the word document. Would like that data in Column J may be pasted in word document in text form automatically. such as:

    abc

    cdc

    xyz

    may be pasted as, abc cdc, xyz etc.

    The macro is:

    Please Login or Register  to view this content.
    Thanks.

    Flower R
    Last edited by Flower R; 12-28-2008 at 07:20 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    Flower R, Word VBA not my forte I'm afraid but given the document is blank (ie new doc) perhaps something along the lines of:

    Please Login or Register  to view this content.
    Change the text in Red to represent the Sheet name on which the J1:J90 resides.

  3. #3
    Forum Contributor
    Join Date
    10-10-2008
    Location
    western hemisphere
    Posts
    126
    Quote Originally Posted by DonkeyOte View Post
    Flower R, Word VBA not my forte I'm afraid but given the document is blank (ie new doc) perhaps something along the lines of:

    Please Login or Register  to view this content.
    Change the text in Red to represent the Sheet name on which the J1:J90 resides.
    Excellent and a perfect solution. Thanks.

+ 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