+ Reply to Thread
Results 1 to 3 of 3

Import data from Word doc to Excel fields

  1. #1
    Registered User
    Join Date
    09-18-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Import data from Word doc to Excel fields

    I have a word doc that has a series of data in it. Each chunk of data is comprised of three parts(Functionality:, Test Case:, and Additional Info: ) I need to search for each of these three words(headings) and then copy the data after it into excel. Column A should be comprised of the data found after the word Functionality. Column B should be comprised of the data found after Test Case, and Column C should be comprised of the data after Additional Info. ANY help is very much appreciated.!

    MY Example (this is what I want to achieve, read from word doc and enter text into excel):

    Word Doc:

    Functionality: Application Options
    Test Case: Cannot enable Express Fill with Order Processing Enabled
    Additional Info:

    1. Set “Enable Order Processing” to “Yes” (Application Options Category: Workflow Corporate)
    2. Set “Enable Express Fill” to “Yes” (Application Options Category: Express Fill)

    Result: User is presented with warning dialog

    Excel Doc(bear with me, I'm trying to make a 3 cell table):
    Row A Row B Row C
    Functionality Test Case Additional Steps
    Application Options[END] Cannot enable Express...(see above)[END] 1. Set “Enable Order.....(see above)[END]

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Import data from Word doc to Excel fields

    Hello Grave,

    Can you attach a copy of the Word document? It will make it easier to follow your post and to write the macro.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Import data from Word doc to Excel fields

    Please post an example Word file and an example Excel-file.

    The way the Word document has been structured (paragraphs, Tabs, tables, sections) can influence the complexity of the macro drastically.



+ 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