View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Ivey Mark Ivey is offline
external usenet poster
 
Posts: 120
Default Excel to Powerpoint - Text Box Properties

Sub TextBox2PPT()

Dim PPApp As Object
Dim PPPres As Object
Dim PPSlide As Object
Dim myFontName As Variant
Dim myFontSize As Long

With Selection.Font
myFontName = .Name
myFontSize = .Size
End With

Set PPApp = GetObject(, "Powerpoint.Application")
Set PPPres = PPApp.ActivePresentation
PPApp.ActiveWindow.ViewType = 9
Set PPSlide = PPPres.Slides(PPApp.ActiveWindow.Selection. _
SlideRange.SlideIndex)

Selection.Copy

PPSlide.Shapes.Paste.Select

PPApp.ActiveWindow.Selection.ShapeRange.TextFrame. TextRange. _
Font.Size = myFontSize
With PPApp.ActiveWindow.Selection.ShapeRange.TextFrame. _
TextRange.Font
.NameAscii = myFontName
.NameOther = myFontName
.NameFarEast = myFontName
End With

Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing
End Sub