Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2015, 07:51 AM
cyraxote cyraxote is offline Macro now fails in Word 2013 after working for more than a year; still works in 2007 Windows 7 64bit Macro now fails in Word 2013 after working for more than a year; still works in 2007 Office 2013
Novice
Macro now fails in Word 2013 after working for more than a year; still works in 2007
 
Join Date: Sep 2015
Location: Essex, MD
Posts: 24
cyraxote is on a distinguished road
Default

OK, I got it all to work. I was able to remove a lot of stuff (commented out here):


Code:
Sub TextToComments()
Dim oDoc As Document
Dim oRng As Range
Dim MyString As String
'Dim myUsername As String
'Dim myUserinitials As String
Dim oComment As Comment

    'myUsername = Application.UserName
    'myUserinitials = Application.UserInitials
    'Application.UserName = "JSmith"
    'Application.UserInitials = "JS"
    Application.ScreenUpdating = False
    Set oDoc = ActiveDocument
    oDoc.TrackRevisions = False
    Set oRng = oDoc.Range
    oRng.Paragraphs.LineSpacingRule = wdLineSpaceSingle
    With oRng.ParagraphFormat
        .SpaceBefore = 0
        .SpaceBeforeAuto = False
        .SpaceAfter = 6
        .SpaceAfterAuto = False
        .LineSpacingRule = wdLineSpaceSingle
    End With
    With oRng.Find
        With .Font
            .Bold = True
        End With
        Do While .Execute(FindText:="(\[*\])", MatchWildcards:=True, _
                Format:=True)
            MyString = oRng.Text
            MyString = Mid(MyString, 2, Len(MyString) - 2)
            If Not Left(MyString, 3) = "TS:" Then
                'MyString = Mid(MyString, InStr(1, MyString, ":") + 2)
                oRng.Text = MyString
                oRng.Delete
                Set oComment = oDoc.Comments.Add(oRng, MyString)
                oComment.Author = "MNathan"
                'If Val(Application.Version) > 14 Then
                '    oComment.Author = Application.UserName
                'End If
                oRng.Font.Bold = False
            End If
            oRng.Collapse 0
        Loop
    End With
    oRng.Collapse 1
    oRng.Select
    Application.ScreenUpdating = True
    'Application.UserName = myUsername
    'Application.UserInitials = myUserinitials
lbl_Exit:
    Set oDoc = Nothing
    Set oRng = Nothing
    Set oComment = Nothing
    Exit Sub
End Sub
Just one final question: do I even need "Application.ScreenUpdating = False" since I'm no longer using the Selection object?

Thanks for all your help. My next project is creating a macro to change a text highlighted in one color to another color, but I want the user to specify both of the colors. It will be my first crack at a userform, I think. Exciting!

Actually, that leads me to a Final final question re: userforms: Is Word's highlight color button (with the little squares of color) available to use in userforms? That would simplify things... maybe.

Thanks again.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro now fails in Word 2013 after working for more than a year; still works in 2007 formula in excel 2007 works not in 2013 piper7971 Excel 10 07-06-2015 02:09 PM
Macro now fails in Word 2013 after working for more than a year; still works in 2007 2013 presentation's animation not working in 2007 captainship PowerPoint 1 04-16-2015 09:35 AM
Macro now fails in Word 2013 after working for more than a year; still works in 2007 Macro fails to add image border in Word 2007 samhdc Word 1 03-30-2012 04:56 AM
Macro now fails in Word 2013 after working for more than a year; still works in 2007 Search always fails in Word 2007 Sachelis Word 2 01-28-2011 08:50 AM
Saving a Word 2007 document as a PDF fails dcabrames Word 20 01-21-2011 03:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft