Excel 2016 - Mac - Excel VBA Macro is failing on PowerPoint.Application.Presentations.Open filename RRS feed

  • Question

  • Getting Automation error -2147024894  when process hits the line of code to open an existing powerpoint presentation. This code worked on Mac Excel 2011 just fine as well as on all windows machines of course.   What changed and what command should I use now to open a powerpoint presentation from vba running on the Mac please?  See code snippet below.

    One other point - when this macro-enabled excel file is opened in Excel 2016, the following alert is displayed.

    "This workbook contains content that isn't supported in this version of excel"

    and then proceeds to give the option to cancel or open as read-only.

    Code snippet

          Dim oPPTApp As PowerPoint.Application

                Dim oPPTShape As PowerPoint.shape

                Dim ActivePresentation As PowerPoint.Presentation

                Dim CompletedPresentation As PowerPoint.Presentation

                Set oPPTApp = CreateObject("PowerPoint.Application")

                oPPTApp.Visible = msoTrue

        ---> failing        Set ActivePresentation = oPPTApp.Presentations.Open(filename)

    Thanks, Lori

    Friday, October 23, 2015 6:40 PM