Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2019, 09:21 AM
JohnWilson JohnWilson is offline PowerPoint macro to change words between quotes to italic needed Windows 10 PowerPoint macro to change words between quotes to italic needed Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,914
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

You could try something based on this:



Code:
Sub regxz()

Dim L As Long
Dim otr As TextRange2
Dim osld As Slide
Dim oshp As Shape
For Each osld In ActivePresentation.Slides
For Each oshp In osld.Shapes
Select Case oshp.Type
Case Is = msoGroup
For L = oshp.GroupItems.Count To 1 Step -1
If oshp.GroupItems(L).HasTextFrame Then
If oshp.GroupItems(L).TextFrame2.HasText Then Set otr = oshp.GroupItems(L).TextFrame2.TextRange
End If
Call fixTR(otr)
Next L
Case Else
If oshp.HasTextFrame Then
If oshp.TextFrame2.HasText Then Set otr = oshp.TextFrame2.TextRange
Call fixTR(otr)
End If
End Select
Next oshp
Next osld
End Sub

Sub fixTR(otr As TextRange2)
On Error Resume Next
Dim oMatches As Object
Dim i As Long
Dim regX As Object
Dim strmatch As String
strmatch = "[" & Chr(147) & "," & Chr(34) & "]" & ".*?" & "[" & Chr(148) & "," & Chr(34) & "]"
Set regX = CreateObject("VBScript.RegExp")
With regX
    .Global = True
    .IgnoreCase = True
    .Pattern = strmatch
    Set oMatches = .Execute(otr)
    For i = 0 To oMatches.Count - 1
       otr.Characters(oMatches(i).FirstIndex + 1, Len(oMatches(i).Value)).Font.Italic = True
    Next i
End With
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #2  
Old 08-21-2019, 03:13 PM
KarenK13 KarenK13 is offline PowerPoint macro to change words between quotes to italic needed Windows 10 PowerPoint macro to change words between quotes to italic needed Office 2013
Novice
PowerPoint macro to change words between quotes to italic needed
 
Join Date: Jul 2019
Posts: 6
KarenK13 is on a distinguished road
Default

Hi John,

I had a new report and tried the macro. It changed words in quotes to italic which I needed but it also changed words between commas to italic. Can that be fixed?

Thanks so much,

Karen
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro needed to copy Powerpoint presentation and sections Marrick13 PowerPoint 0 06-19-2017 07:34 AM
PowerPoint macro to change words between quotes to italic needed Help Needed with Macro to Change Formulas to Text Using Ranges rsrasc Excel Programming 2 11-29-2016 02:31 PM
PowerPoint macro to change words between quotes to italic needed How to replace straight quotes with smart quotes in existing document PABwriter Word 4 05-27-2016 03:36 PM
PowerPoint macro to change words between quotes to italic needed repel Macro vba help is needed for interactive powerpoint. Mrs Blobby PowerPoint 1 04-16-2014 10:58 PM
PowerPoint macro to change words between quotes to italic needed Regular Expressions: match words within quotes? tinfanide Word VBA 3 02-02-2013 10:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 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