Another department sends out enormous status reports in the form of a 20-page
long Word table every week. (7 columns with headers, many rows). I've been
kind of laboriously copying/pasting/reformatting the thing into Excel so that
I can analyze the thing more effectively, but it's always rather painful.
(And there's no way they'll ever just convert the thing to Excel permanently.)

Is there a macro that would copy the contents of each cell from the table in
the Microsoft Word document into an equivalent cell in an Excel template that
I could just empty out and refill every week? Complicating things is the
format the table is in: Whoever puts this thing together insists on merging
all the cells in a row to make intermediate heads that appear throughout the
table.

Thx in advance, everyone!

You could save the Word file in html format, then open it with Excel.

V. Hatherley wrote:
Another department sends out enormous status reports in the form of a 20-page
long Word table every week. (7 columns with headers, many rows). I've been
kind of laboriously copying/pasting/reformatting the thing into Excel so that
I can analyze the thing more effectively, but it's always rather painful.
(And there's no way they'll ever just convert the thing to Excel permanently.)

Is there a macro that would copy the contents of each cell from the table in
the Microsoft Word document into an equivalent cell in an Excel template that
I could just empty out and refill every week? Complicating things is the
format the table is in: Whoever puts this thing together insists on merging
all the cells in a row to make intermediate heads that appear throughout the
table.

Thx in advance, everyone!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html