In order to control PowerPoint from inside Excel's Visual Basic Editor, we need to teach Excel how to speak in PowerPoint's terms.  PowerPoint uses a vocabulary containing terms such as "Slide" and "Presentation" that simply do not exist in Excel's own code language.  



To activate PowerPoint's object library:

With Reference to the following code block:

______________________________________

'Create an Instance of PowerPoint

  On Error Resume Next

    

    'Is PowerPoint already opened?

      Set PowerPointApp = GetObject(class:="PowerPoint.Application")

    

    'Clear the error between errors

      Err.Clear



    'If PowerPoint is not already open then open PowerPoint

      If PowerPointApp Is Nothing Then Set PowerPointApp = CreateObject(class:="PowerPoint.Application")

    

    'Handle if the PowerPoint Application is not found

      If Err.Number = 429 Then

        MsgBox "PowerPoint could not be found, aborting."

        Exit Sub

      End If



  On Error GoTo 0



_____________________________________________



Choose all the answers which are CORRECT:

The Cells(i,j) property belong to the Range Object:

How do you TRACE, or VIEW, the values of Variables when code is being stepped through?

When applying STYLES in Excel, you will: