+ Reply to Thread
Results 1 to 3 of 3

Getting Word data into Excel

  1. #1
    Randy Harris
    Guest

    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.

  2. #2
    Ed
    Guest

    Re: 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" <[email protected]> wrote in message
    news:%[email protected]...
    >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.




  3. #3
    Randy Harris
    Guest

    Re: 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" <[email protected]> wrote in message
    > news:%[email protected]...
    >> 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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1