Ladies, Gents,
I have a standard report as a Word document file that needs certain cells copied into it from an Excel spreadsheet via the macro in the same excel file.
The cell information must be pasted into the correct spots via a text match in th eWord document eg "Add Excel cell A1 after me:-"
It has a number of the text copy/pasting, plus I require a "Paste Special" of an Excel chart onto a last blank page in the Word document.
I have never done an excel macro that crosses over into Word before.
Any help would be much appreciated.
Regards
Chris
I have a standard report as a Word document file that needs certain cells copied into it from an Excel spreadsheet via the macro in the same excel file.
The cell information must be pasted into the correct spots via a text match in th eWord document eg "Add Excel cell A1 after me:-"
It has a number of the text copy/pasting, plus I require a "Paste Special" of an Excel chart onto a last blank page in the Word document.
I have never done an excel macro that crosses over into Word before.
Any help would be much appreciated.
Regards
Chris
