Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2014
    Posts
    1
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Copying Excel data to Word

    hi all,
    I am new to excel vba and happy to say, my life has changed by learning vba.

    I have to copy paste large number of data from excel to word file.

    This excel file contains objects(shapes) and text. How can I copy all these data into word.
    Note : I need to copy all the text as text only.

    Thank you for your help.

    Regards,
    Ravichandran JAYAPRAKASH

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,898
    Thanks
    0
    Thanked 188 Times in 172 Posts
    You can copy & paste the content, with formatting, then remove the formatting later on, so as to keep the relationship between the text & other objects intact. It's only if you want to remove any table structure that the content has that you'll encounter problems with the relationship between the text & other objects.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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