I am writing a macro which embeds a blank Word document
into an Excel spreadsheet. After embedding the document
(which works), I want to copy information from the Excel
spreadsheet into the embedded Word document. Although I
can manually copy and paste the information, I cannot
figure out how to get the macro to do this. When I use
record macro, it stops recording as soon as I enter the
Word document. When I look directly at the code, I can't
find a command that will do the pasting? Is there a way to
do this? If so, what is the code for it? Thank you.