Why do you need a macro? Can't you just copy the data and paste them into Excel? Aside from which, you haven't told us whether you want to use an existing workbook or a new one, etc.

PS: Unnecessarily quoting entire posts just adds clutter.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]