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: mrexcel & msofficeforums but I can't post links.)