Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Help needed: Transfer Word tables to Excel

by Rz1986 Oct 29, 2007 3:14AM PDT

Hi guys...I have this very short notice urgent task to accomplish at work.

We have a directory with a bunch of MS word documents that contain hundreds of tables within each document including some text.

An automation tool is required that would detect and copy all the tables contained within the word document and copy them into a new MS excel sheet.

I have done soo many searches and I am clueless right now as how I should approach this problem. Suggestions from you guys will be appreciated.

Thanks!

Discussion is locked

4 Posts
- Collapse + Expand Details
- Collapse -
It usually takes..
by r. proffitt Forum moderator Oct 29, 2007 3:33AM PDT

1. An experienced owner, almost a programmer and ..
2. Possibly WORDPIPE (see google.com)
3. And maybe some VB and VBA code (see item 1 for who writes it)

What you ask is possible but requires some work since there are no "buttons" that do this automatically.

Bob

- Collapse -
Thanks Bob
by Rz1986 Oct 29, 2007 3:56AM PDT

Thanks Bob,

I appreciate your input. I'll look into the list you gave me. But lets say we do not want the tool to detect the tables. It can just copy everything there is in the word doc into an excel sheet but the tables formatting should remain the same as the format of the word doc. Is this an easier task to achieve?

- Collapse -
Sorry.
by r. proffitt Forum moderator Oct 29, 2007 3:58AM PDT

I wonder if you felt the tool was WORDPIPE. It's just a tool to lighten the load on the person writing the VB or VBA code. My feelings is that it's cheap compared to the cost per hour of the programmer.

Bob

- Collapse -
Perhaps...
by Papa Echo Oct 29, 2007 2:07PM PDT

...it would make things "easier" if you can share why you want to do it. It is routine to tranfer some Word tables to an Excel worksheet, but "hundreds" at a time ?

Back to Office & Productivity Software forum

CNET Forums

Operating Systems
Software
Electronics & Gadgets
Hardware
Tablets & Mobile Devices
General Help
Brand Forums
Roadshow Autos
Off Topic

Other Forums

Forum Info