Greetings, all -

I'm an experienced relational database developer who is pretty much a
newbie as far as Excel development is concerned. I have been wracking my
brain trying to figure out how to export the contents of a worksheet to
(or as) a Word document without having to resort to macros (partly
because this workbook will be both emailed and copied into PocketExcel,
so any macros would likely be lost; and partly because I find the Word
object model completely baffling). Now, Access has this nifty feature
called "OfficeLinks" on the toolbar, which provides shortcuts like
"Analyze It With Excel," "Publish it with Microsoft Word," and "Merge it
with Microsoft Word." Although this is still available in AXP, Excel XP
does not appear to offer this functionality. IIRC, good ol' XL97 had
something kind of similar...shortcut commands from the Data menu which
created an Access forms or generated an Access report (which could THEN
be sent to Word...very circuitous!) from a worksheet, & added a control
to the worksheet to take you directly to the form/report with a click.
But again, these are nowhere to be found in XP. My goal is to create a
userform with a button that the user can click to generate a printable
report. Any ideas, suggestions, comments, etc. would be greatly appreciated!

tia,

LeAnne