Home > Archive > Visual Basic > November 2005 > Export Information from Word to Excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Export Information from Word to Excel
|
|
| jamesftoland@gmail.com 2005-11-28, 6:56 pm |
| Hi,
Although there seems to be plenty of ways to move data from Excel to a
Word doc, I need a script that would move some selected field
information from a Word doc to an Excel spreadsheet (notably, 4 or 5
cells within a single row in Excel)
Can anybody point me in the right direction?
Thanks in advance
J
| |
|
|
<jamesftoland@gmail.com> wrote in message
news:1133211333.997112.224590@f14g2000cwb.googlegroups.com...
> Hi,
>
> Although there seems to be plenty of ways to move data from Excel to a
> Word doc, I need a script that would move some selected field
> information from a Word doc to an Excel spreadsheet (notably, 4 or 5
> cells within a single row in Excel)
>
> Can anybody point me in the right direction?
>
> Thanks in advance
>
> J
>
Your question depends on how your data can be located and how it is
'structured' in the Word Doc, and how well this information transfers to an
Excel 'structure'.
For example, here is one way to capture a 'labeled' table from a group of
word documents...
Transferring Tables in Multiple MS Word Documents to an Excel Spreadsheet
http://visualbasic.ittoolbox.com/do...ar-q-and-a/3158
If the data was formatted somewhat differently, you would need to take a
different approach - for example, if you wanted to capture Memo data, like
To:, From:, Re:, Date:, etc. You would have to either search for those
styles, or defined Document attributes, fields, text, etc. (That's why you
don't see many examples - there is such a wide range of possibilities.)
I would start out with a simple 'Word' s er (capture the data) and a
simple 'Excel' putter (update). Then go from there.
hth
-ralph
|
|
|
|
|