A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | 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 |