+ Reply to Thread
Results 1 to 3 of 3

Macro copies and pastes to word, need to modify to copy and paste additional cell values

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Macro copies and pastes to word, need to modify to copy and paste additional cell values

    I have the following macro which will copy and paste some info from an excel workbook into a word document at the end of the document. I also insert the following text, "E1RM-" "Total Volume-" and "Average Intensity-" at the end.
    After the "E1RM-" I need to paste in the value found in cell R1.
    After the "Total Volume-" I need to paste in the value found in cell R2.
    After the "Average Intensity-" I need to paste in the value found in cell R6.
    So after the macro is run the word document looks like this,
    E1RM-6
    Total Volume-7
    Average Intensity-8%

    The actual values used in the example are for demonstration purposes only.
    The cell references come from the same sheet as the cell range comes from earlier in the macro, the Calculator sheet.
    I was working off of a youtube video which used the find function to decide where to place a value, however that wouldn't work in this situation because the word document would have the inserted text in it numerous times.
    How do I modify the macro so that it functions as described?

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Macro copies and pastes to word, need to modify to copy and paste additional cell valu

    I modified the code as follows and the problem is that when the cell values are inserted into word they are inserted as an excel cell, surrounded by the dotted blue line. I need them to appear as if they were typed into word normally.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Macro copies and pastes to word, need to modify to copy and paste additional cell valu

    I figured it out, for reference I will leave the code here.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro copies and pastes to word, replaces entire doc rather than add to end of doc
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-05-2014, 06:09 PM
  2. Replies: 2
    Last Post: 12-05-2012, 10:43 PM
  3. Replies: 1
    Last Post: 10-03-2012, 07:06 PM
  4. Replies: 2
    Last Post: 09-05-2012, 03:20 PM
  5. [SOLVED] Automating a macro that copies and pastes data and pastes 2 rows under the previous one.
    By thebank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 05:02 PM

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