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.
Bookmarks