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 |