Solved

MsgBox listing all outline level 1 headings

Posted on 2008-11-02
3
265 Views
Last Modified: 2012-05-05
Dear Experts:
Below macro lists all outline level 1 headings in a msgbox. Can this macro be expanded to list also the paragraph style name in the msgbox such as:

Section 3: List of Tables, Heading_List
Section 4: List of Figures, Heading_List
Section 5: 1 Introduction, Heading 1
Section 6: 2 Analysis, Heading 1
........
Section 12: Bibliography, Heading_End
Section 13: Appendix, Heading_End

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Sub ListOutlineLevel1ParaMsgBox()
Dim oPara As Paragraph
Dim strMsg As String
Dim rTmp As range ' a temporary range
Dim lTmp As Long  ' sections count
Dim l2Tmp As Long
 
Set rTmp = ActiveDocument.range
'Create start of message
strMsg = "Outline Level 1: " & vbCr
'Iterate through all paragraphs in active document
'If style has outline level 1, append to message
For Each oPara In ActiveDocument.Paragraphs
   If oPara.OutlineLevel = wdOutlineLevel1 Then
'   strMsg = "Outline level 1: " & vbCr
 
      With oPara.range
      rTmp.End = .End ' redefine the temporary range
      lTmp = rTmp.Sections.count ' count the sections
     
      
      'Append the heading number and text to the message
      strMsg = strMsg & " section: " & CStr(lTmp)
      strMsg = strMsg & "  " & .ListFormat.ListString & "  " & .Text _
      & "  "
      
      End With
      End If
Next oPara
MsgBox strMsg, vbOKOnly, "Summary Outline Level 1"
End Sub

Open in new window

0
Comment
Question by:AndreasHermle
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 22862353
Hello AndreasHermle,

Keeping with what you have and making small changes ... try the following

Regards,
Chris
Sub ListOutlineLevel1ParaMsgBox()
Dim oPara As Paragraph
Dim strMsg As String
Dim rTmp As Range ' a temporary range
Dim lTmp As Long  ' sections count
Dim l2Tmp As Long
 
Set rTmp = ActiveDocument.Range
'Create start of message
strMsg = "Outline Level 1: " & vbCr
'Iterate through all paragraphs in active document
'If style has outline level 1, append to message
For Each oPara In ActiveDocument.Paragraphs
   If oPara.OutlineLevel = wdOutlineLevel1 Then
'   strMsg = "Outline level 1: " & vbCr
 
      With oPara.Range
      rTmp.End = .End ' redefine the temporary range
      lTmp = rTmp.Sections.Count ' count the sections
     
      
      'Append the heading number and text to the message
      strMsg = strMsg & " section: " & CStr(lTmp)
      strMsg = strMsg & "  " & .ListFormat.ListString & "  " & Left(.Text, Len(.Text) - 1) & _
      vbTab & oPara.Range.Font.Name & vbCrLf
      
      End With
      End If
Next oPara
MsgBox strMsg, vbOKOnly, "Summary Outline Level 1"
End Sub

Open in new window

0
 

Author Comment

by:AndreasHermle
ID: 22864791
Dear Chris,
thank you for your professional help. I slightly changed the code to "oPara.range.Style" instead of "oPara.range.Font.Name" (at the very end before "End With") . My requirment was actually to add the paragraph style name.  With your help I was able to change that myself.

Again, thank you for your professional help. Regards, Andreas
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 22864892
Apologies for my oversight and well done to correct it yourself

Chris
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
clicking a shape in a frame array vb6 3 45
How to take a hard copy form and make it a fillable soft form? 9 47
RUNRMTCMD from AS/400 12 50
Word Perfect Question 11 20
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question