+ Reply to Thread
Results 1 to 1 of 1

Macro to copy/paste picture of table in Excel worksheet into a Word document

  1. #1
    Registered User
    Join Date
    09-28-2016
    Location
    Dallas, TX
    MS-Off Ver
    Office 365
    Posts
    15

    Macro to copy/paste picture of table in Excel worksheet into a Word document

    I am having trouble with a macro I have written to copy/paste a picture of a table found in an Excel Worksheet into a Word document at a location specified by my current cursor location. It works fine the first time I run the Macro; however, when the table in Excel is updated with new data, the macro comes back with an error on subsequent attempts to operate it. Can anyone look at it and help? I am attaching both the Word and Excel document. The place in question is HISTORICAL PERFORMANCE TRENDS (page 5 I think)...you can follow the instructions in the Word document from there. Must have the Excel document downloaded as well. Actually, can't upload the Word .docm file.

    I want the user to be able to run a hotkey in Word that runs the Macro that takes the first chart and embeds a picture of it in the Word doc. There should be a separate hotkey for each chart being added into the Word doc.

+ 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. Macro to copy and paste from another Word 2007 document.
    By Excelnoub in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 09:06 PM
  2. Copy data from Excel and paste it in a table in word document
    By shekhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 05:28 AM
  3. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  4. Paste large excel worksheet into word document
    By amyinmd in forum Excel General
    Replies: 1
    Last Post: 02-23-2009, 10:29 AM
  5. Macro excel to copy and paste table from Word
    By Shunlee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2008, 06:52 AM
  6. Replies: 1
    Last Post: 10-17-2005, 04:05 AM
  7. macro to copy selection and paste special as picture in word
    By rabbi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 09:29 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