ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Word data into Excel (https://www.excelbanter.com/excel-programming/368716-getting-word-data-into-excel.html)

Randy Harris[_2_]

Getting Word data into Excel
 
I need to import field data from a number of Microsoft Word documents
into Excel with code, but am pretty much lost. Can anyone give me an
idea of how to go about doing that?

Thanks for any suggestions.


--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Ed

Getting Word data into Excel
 
Hi, Randy. I just posted some code for reading a Word document as an answer
to pikapika13, "Open Word and fetch specific data". Parts of this may or
may not work for your application.

I haven't done any work with Word field data, but I know you could open the
doc and get the data using objDoc.Fields(x).Result (where objDoc is your
Word document object and x is the index number of the field you need to
access).

HTH
Ed

"Randy Harris" wrote in message
...
I need to import field data from a number of Microsoft Word documents into
Excel with code, but am pretty much lost. Can anyone give me an idea of
how to go about doing that?

Thanks for any suggestions.


--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.




Randy Harris[_2_]

Getting Word data into Excel
 
* Ed:
Hi, Randy. I just posted some code for reading a Word document as an answer
to pikapika13, "Open Word and fetch specific data". Parts of this may or
may not work for your application.

I haven't done any work with Word field data, but I know you could open the
doc and get the data using objDoc.Fields(x).Result (where objDoc is your
Word document object and x is the index number of the field you need to
access).

HTH
Ed

"Randy Harris" wrote in message
...
I need to import field data from a number of Microsoft Word documents into
Excel with code, but am pretty much lost. Can anyone give me an idea of
how to go about doing that?

Thanks for any suggestions.


--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.




Thanks Ed, I think that will be a LOT of help.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com