importing excel spreadsheeting into word tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barbara - 30 Sep 2004 00:21 GMT

I work with people who insist on using Excel for text documents instead of
Word tables.

I'd like to import the data into a word table to show them how much more
convenient and easy it would be to use Word than Excel.

I've tried several ways to copy and paste rows or columns of data, as well
as the whole worksheet into a word table with limited success. I don't want
to spend hours correcting the document for demonstration purposes.

If you have any suggestions, I'd love to hear them

Reply to this Message

Anne Troy - 30 Sep 2004 17:45 GMT

You'd really have to tell us the problems you're having for us to offer up
solutions. A nicely formatted Excel workbook will copy over nicely into Word
tables. Alternatively, maybe you should let them keep their **** Excel and
use Mailmerge to layout the data?
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

> I work with people who insist on using Excel for text documents instead of
> Word tables.
[quoted text clipped - 7 lines]
>
> If you have any suggestions, I'd love to hear them

Reply to this Message

Barbara - 30 Sep 2004 23:23 GMT

The excel "table is 7 columns across and about 50 rows deep. The problem I
believe lies with merging rows. When I copy the worksheet and paste special
(I've tried all the flavors of special) I get a teeny tiny graphic of the
page in the upper left hand corner of the word doc. I haven't tried
mailmerge, nor have I tried unmerging all the excel cells and then copying to
word and then deleting all the unnecessary cells. We're all on Wxp so the
double byte issues should no come into play (the doc is English and Japanese).

I'd leave it alone, but you can't print out the excel sheet without losing
some of the content in the cells. Everything can be read on the screen, but
in a meeting, everyone wants the papaer document in front of them, and that
is not possible at this point. Thanks!

> You'd really have to tell us the problems you're having for us to offer up
> solutions. A nicely formatted Excel workbook will copy over nicely into Word
[quoted text clipped - 18 lines]
> >
> > If you have any suggestions, I'd love to hear them

Reply to this Message