[macropod]

Hi Sean,

One way to expedite the process is with a macro. It could be in either your Word Document or your Excel Workbook and, although the
code would execute in much the same fashion, you'd need different code depending on which app does the automation.

Another way, if your data ranges in Excel are named, is to Copy one such range in Excel, then use Edit|Paste Special|Link in Word
(choose whatever format you want). In Word you could then:
.. press Alt-F9 to expose the field coding
.. copy & paste the link field as many times as needed
.. edit the named ranges in the field copies
.. press F9 to update the links, then Alt-F9 again to toggle the field code display off.
At this point, your Word and Excel files are linked so that any changes in the Excel file will be reflected in Word. You may or may
not want that. If not, select the linked objects and press Ctrl-Shift-F9 to break the links.

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

wrote in message ups.com...
I have a large Excel document with about 50 tabs. On each tab is a
formatted table with data.

I would like to export all of these tables into a Word document
without having to hit "Copy" and "Paste" 50 times. Is there a way for
me to automatically export all of these tables into Word?

Thank you!!!!