I have a workbook of 5 sheets which populate an open template Word document
with data at 5 specific bookmarks. The macro needs to return to Excel after
each sheet has been processed.
I can't get the macro to paste at the desired bookmark or carry out
formatting on the Word document. I've tried using SendKeys without success
(looks as if this anticipated from other threads here) and I've tried pasting
a Word macro into the Excel macro (also suggseted here).
Any help gratefully received by a new boy.