+ Reply to Thread
Results 1 to 2 of 2

Copy table in excel and paste as text in word

  1. #1
    Registered User
    Join Date
    09-09-2010
    Location
    Philadelphia PA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Copy table in excel and paste as text in word

    I am working on a macro that has three parts:

    Part 1: Combine text in an existing xl sheet.
    Part 2: Copy a column
    Part 3: Paste the copied cells in word as text.

    There are some issues with the second and third part.

    The second part copies the text in a range of cell. Given my almost non existent VBA skills, I am copying a specified range. However, the ideal situation would be when the macro identifies that there is text in the cell and selects and copies the column.

    The third part is supposed to paste the copied cells as text in a new word document. However, there are following issues:

    1. The cells are pasting as table. However, I want them to paste as text in the word document.
    2. The word document closes automatically. Is there a way for it to stay open?

    Please see the attached sheet!!

    I would very much appreciate if someone can help me fix this.
    Thanks,
    H
    Attached Files Attached Files
    Last edited by himanshu83; 09-24-2012 at 10:12 AM.

  2. #2
    Registered User
    Join Date
    09-09-2010
    Location
    Philadelphia PA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Copy table in excel and paste as text in word

    If copying range from excel and pasting it in word as text is complicated, is there another way to combine text in the cells in the range (either in a new textbox or a cell??

    Please advise.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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