MAC VBA to copy values from Excel to PPT

[hserk]

Hi There

I am trying to port a macro from windows to mac vba.
The macro opens an excel workbook, opens a ppt template, and copies values from one to the other.
Both files are opened successfully by file dialog prompt.

However, when the (excel) script tries to interact with the (open) powerpoint file, the excel script just dies:

//this script is run in excel workbook
Sub TestPpt()

'Step 1: Declare your variables
Dim DestinationPPT As String
Dim PP As PowerPoint.Application
Dim myPres As PowerPoint.Presentation
Dim mySlide As PowerPoint.Slide
Dim mySlides() As Variant


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

DestinationPPT = "/Users/sysadministrator/Documents/End of Qstream Report/testpres.pptx"

Set myPres = PP.Presentations.Open(DestinationPPT)

Set myPres = PP.ActivePresentation


//but dies on this line
Set mySlide = myPres.Slides(1)

mySlide.Shapes("insights_title").TextFrame.TextRange.Text = qsTitle


End Sub




Does anyone know if cross-app interaction like this is possible on a mac?

Thanks!

[chooriang]

1. I think you don't need to re-set myPres (remove or comment Set myPres = PP.ActivePresentation)

2. Is there any slide in DestinationPPT?

3. Try late binding instead of early binding.

Don't have MAC machine to test it myself.