Hi.

I need to generate reports in Word, where the content of those reports
is copied from selected parts of an Excel spreadsheet.

Please provide detailed guidance on creating an Excel macro to:
A. Paste selected cells from an Excel XLS into a new Word doc.
B. Run Word VBA code (via the same Excel macro) to reformat those
cells in Word.

More specifically ...

A. I need the Excel macro to:
(1) Copy the currently selected cells onto the Windows clipboard.
(2) Open Word and start a fresh document.
(3) Paste the contents of the clipboard into the new Word doc.

B.