+ Reply to Thread
Results 1 to 2 of 2

Numbered Word list into Excel

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1

    Numbered Word list into Excel

    Let's say that a Word document contains a standard numbered list somewhere within its body.

    Blah, blah, blah
    1. Good point
    2. Better point
    Blah, blah, blah
    3. Counter point
    Blah, blah, blah
    4. Summary
    Blah, blah, blah

    Using VBA, I am trying to extract only the numbered list(s), ignoring the other text, into an Excel spreadsheet. I can easily identify each paragraphs outline level and style using something like:

    For Each para In WordDoc.Paragraphs
    if para.outlineLevel < 10 then
    do whatever
    end if
    Next

    But when the actual numbered list is being imported, the numbers from he list themselves get dropped, so the actual output from the above snippet pasted into Excel will look like:

    Good point
    Better point
    Counter point
    Summary

    What's the way to import the entire line from the numbered list, including the list numbering?

    Cheers,
    Michal

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Numbered Word list into Excel

    The list numbers are found through:
    para.Range.ListFormat.ListString

    so, something like this for the 'full' text

    para.Range.ListFormat.ListString & " " & para.Range.Text
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine cells of portions of a numbered list into a continous numbered list
    By AusTempest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2014, 01:55 AM
  2. Word Numbered List to Excel?
    By mazingerZ in forum Excel General
    Replies: 4
    Last Post: 09-20-2009, 09:58 PM
  3. Creating sequentially numbered form using Word 2007
    By alanda in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2009, 10:17 AM
  4. how do i create a customised numbered list in excel
    By Franw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-18-2006, 01:30 AM
  5. [SOLVED] How do I set up raffle tickets to be numbered in Word
    By connie in forum Excel General
    Replies: 1
    Last Post: 10-05-2005, 05:05 PM

Tags for this Thread

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