Load PowerPoint Object Library on Excel - 'Error in loading dll'

0
votes

I am trying to load the 'Microsoft PowerPoint 14.0 Object Library' in VBA.

I am using a Mac and Excel 2016.

Sub MyPPT()
Dim VBProj As VBIDE.VBProject

Set VBProj = ThisWorkbook.VBProject

VBProj.References.AddFromFile Environ("systemroot") & "/system32/Microsoft PowerPoint.tlb"

Set VBProj = Nothing

End Sub

I get

Run-time error '48':
Error in loading DLL

1
excelvbamacos
The reference 'Microsoft Visual Basic for Applications Extensibility 5.3' is already loaded. – Pietro

1 Answers

1
votes

I'm not a Mac user, but I'm pretty sure there is no System32 folder on a Mac. Are you sure that the path is correct?

Based on this article, the path should be something like :

/Applications/Microsoft Excel.app/Content/SharedSuppo...