By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (32 of 1075)

(Clear Filter = *PPT*)

Dim PPT As Powerpoint.Application
Set PPT = CreateObject("Powerpoint.Application")
Set PPApp = GetObject(, "Powerpoint.Application")
PPT.Visible = True
PPT.Presentations.Open sFile, ReadOnly:=msoTrue
deleteSlide ' ppt routine
Generate_deck - udf - that runs commands in spreadsheet to generate ppt slides
CopyChartToPPT ... udf - very important
UpdateTOC - code to update ppt toc
PPT.ActivePresentation.SaveAs sFile
PPT.ActivePresentation.Close
LogWaitTime - track time my machines is unavailable due to PPT code running
GenerateAllExcelAndDecks - batch - run multiple SQL's and Creates multiple PPT decks
Application.Run - can be used to run a passed function on parameters - code in pptools - Callback_testing
PPT test code to update embedded spreadsheet in ppt
GetActivePPT - get a reference to active ppt
PPT.ActivePresentation.Save
Set ppttemplate = PPT.Presentations.Open(sFile, ReadOnly = msoTrue
PPT.ActivePrenstation.Slides(2).select
GetAllSlideNames
PPT.ActiveWindow.Selection.SlideRange.SlideNumber - get the active slides #
PPT.ActivePresentation.Slides(n) - the nth slide oblect name to use in a with stmt
For each shp in PPT.ActivePresentation.Slides(2)
If pptshape.name like "xxxxx"
pptshp.HasTable
pptshp.Table.Rows.count
pptshp.table.Columns.Count
PPT.ActivePresntation.Slides.count - gets the last slide
pptshp.Table.Cell(i, 1).Shape.TextFrame.TextRange.Text - gets the text from a pptshp cell
Setting a Hyperlink on a cell in a ppt table
UpdateHyperLinkTOC - PPT
PPT Object Model
Top
   
Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit