Solved

How to Select Every Other Line in a Word Document Using VBscript

Posted on 2013-01-05
9
2,331 Views
Last Modified: 2013-01-05
Hello Experts.
I've been trying to create a simple macro that goes through a small word document and select all text on every other line. I have hundreds of documents where I have to do this manually, and it would really help if I could get a macro to do it.
It's definitely not correct, but here's the script I have right now:
Sub HighlightAlternateLines()
  Dim par As Paragraph
  For Each par In ActiveDocument.Paragraphs
    Selection.ExtendMode = True
    Selection.Expand wdParagraph
    GoDown = Selection.MoveDown(Unit:=wdLine, Count:=2)
  Next
End Sub

Open in new window

Any assistance you can offer would be fabulous.

Best,
Tony
0
Comment
Question by:tonygardner1
  • 4
  • 4
9 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 38746575
Not clear what you expect to achieve. This will do it, but when it stops only the last odd paragraph is selected, since the previous odd paragraphs are not contiguous.
Sub SelectAlternateParagraphs()
    Dim par As Paragraph
    Dim Odd As Boolean
    
    For Each par In ActiveDocument.Paragraphs
        Odd = Not Odd
        If Odd Then
            par.Range.Select
        Next
    Next par
End Sub

Open in new window

0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 38746587
There is only one Selection object in a Word application with a single Start and a single End property, so making a selection automatically deselects what was previously selected.
0
 
LVL 8

Expert Comment

by:stevepcguy
ID: 38746637
Could you clarify what you want to achieve with this? As already stated, you can have only one object selected at a time, unlike Excel, where you can have multiple groups of cells selected at once.

Is this to make every other line shaded a particular color? Make it bold, perhaps? That could be done using the For/next loop, but we would need to know what you plan to do.
0
 

Author Comment

by:tonygardner1
ID: 38747474
Thanks Graham and Steve for the helpful responses. I guess I was hoping to find a VBscript equivalent to do what I'm doing manually which is holding the Mac Command button (Ctrl in Windows) and clicking to the left of every other line. Once the alternate lines are selected, I set their color to wdColorDarkBlue. The reason I wanted to have the selection process be a separate macro was in case the lines whose text needs to be dark blue are not perfectly setup. For example, there might be some preliminary text that is inserted.

The perfect VBscript to accomplish my objective would need to go through the words on the line to see if they meet a certain percentage of pre-defined criteria, and if so, set the entire line to dark blue and move on to the next. For simplicity sake, let's say that the criteria is that the first letter of all words is [A-G], and the percentage must be greater than or equal to 90%.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 38747567
It sounds as if you need something like this:
Sub RecolourSomeParagraphs()
    Dim par As Paragraph
    Dim Odd As Boolean
    Dim wrd As Range
    Dim FirstLetterCount As Integer
    
    For Each par In ActiveDocument.Paragraphs
        Odd = Not Odd
        If Odd Then
            Debug.Print par.Range.Text
            FirstLetterCount = 0
            For Each wrd In par.Range.Words
                Select Case wrd.Characters.First
                    Case "A" To "G", "a" To "g"
                        FirstLetterCount = FirstLetterCount + 1
                End Select
            Next wrd
            Debug.Print FirstLetterCount, FirstLetterCount / par.Range.Words.Count
            If FirstLetterCount / par.Range.Words.Count >= 0.9 Then
                par.Range.Font.Color = wdColorDarkBlue
            End If
        End If
    Next par
End Sub

Open in new window


Incidentally, this is VBA, not VBScript.
0
 

Author Comment

by:tonygardner1
ID: 38747685
Wow, Graham. This looks really promising. I tried it on my test document, but the lines that should have met our criteria didn't get set to dark blue.

Also note that we no longer need to worry about alternate lines since we're now checking every paragraph. I did try commenting out the lines referencing Odd/Even, but that didn't seem to help.

I have attached a sample document where the objective would be to have all lines containing guitar chords set to dark blue.

Thanks Again,
Tony G.
The-Quick-Brown-Fox.docx
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 38747713
The chord lines have many spaces, so this code simply looks for paragraphs containing 10 or more adjacent spaces.
Sub RecolourChordParagraphs()
    Dim par As Paragraph
    Dim wrd As Range
    Dim FirstLetterCount As Integer
    
    For Each par In ActiveDocument.Paragraphs
        If InStr(par.Range.Text, String(10, " ")) Then
            par.Range.Font.Color = wdColorDarkBlue
        End If
    Next par
End Sub

Open in new window

0
 

Author Comment

by:tonygardner1
ID: 38748073
Thanks ever so much, Graham. That's really good thinking. I really appreciate your help.
0
 

Author Closing Comment

by:tonygardner1
ID: 38748074
Excellent work!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now