Chapter 23 Currency conversion

chart

code to move from excel to ppt

Sub ExcelToNewPowerPoint()
Dim PPApp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide

' Create instance of PowerPoint
Set PPApp = CreateObject("Powerpoint.Application")

' For automation to work, PowerPoint must be visible
' (alternatively, other extraordinary measures must be taken)
PPApp.Visible = True

' Create a presentation
Set PPPres = PPApp.Presentations.Add

' Some PowerPoint actions work best in normal slide view
PPApp.ActiveWindow.ViewType = ppViewSlide

' Add first slide to presentation
Set PPSlide = PPPres.Slides.Add(1, ppLayoutTitleOnly)

''---------------------
'' Do Some Stuff Here
''---------------------




' Save and close presentation
With PPPres
.SaveAs "C:\powerpoint\kevin_mining_model.ppt"
.Close
End With

' Quit PowerPoint
PPApp.Quit

' Clean up
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing

End Sub

Excel to PowerPoint

Business Intelligence, Rapid Application Development With Excel VBA, OLAP Design, SSRS Development And ETL - Consultancy Service Providers

Business Intelligence, Rapid Application Development With Excel VBA, OLAP Design, SSRS Development And ETL - Consultancy Service Providers

cool

Brain Rules for Presenters

From: garr, 1 month ago

| View | Upload your own

One of the best books I have read this year is Brain Rules: 12 Principles for Surviving and Thriving at Work, Home, and School. The applications for presentation are many. This is a book review of sorts, though I do not highlight all aspects of the book. I focus on the three rules that relate most directly, though all the rules have lessons. Just a fantastic book.


SlideShare Link