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
Bookmarks