I have a Word document that I already run several macros on. I now want to add an additional macro that will do the following (I'm not sure if this can all be done through a Word macro or if after opening the spreadsheet I need to run another macro through Excel.)

• From the open Word document (named "workingquote.docx",) open a spreadsheet with the name "WorkingSheet.xlsm"
• Prompt user for data to input in several cells (I figured out the code to do this part in an excel macro but not sure if it can be done through the word macro?) This data updates a graph
• Copy a range of cells in excel document to the clipboard
• Switch back to the word document named "workingquote.docx" & go to a bookmark named "ROITable" and paste the data from the clipboard
• Switch back to Excel doc "WorkingSheet.xlsm", copy a graph named "SolarValue"
• Switch back to the word document named "workingquote.docx" & go to a bookmark named "ROIGraph" & paste into the Word document named "workingquote.docx".
• Close the excel document (don't need to save it but do need to retain the data in the word document)

Cross posted to:
https://www.mrexcel.com/forum/genera...xcel-word.html
https://www.excelforum.com/excel-pro...l-to-word.html

There are many examples of code on all three forums for automating Word from Excel and vice-versa. I suggest you do a search for some code you can adapt and, if you run into difficulties with the implementation, post back with the specifics.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

See if https://www.gmayor.com/mail_merge_charts.htm or https://www.gmayor.com/mail_merge_charts_2.html helps

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com