I'm trying to open a Powerpoint document within my Excel VBA code but I keep getting the following error message:
'Object doesn't support this property or method'
My code looks like this:
Dim PowerpointApp As Object
Dim PowerpointDoc As Object
Set PowerpointApp = CreateObject("Powerpoint.Application")
Set PowerpointDoc = PowerpointApp.Documents.Open(gcCertificateTemplatePath)
PowerpointApp.Visible = True
It falls over at the open of the document. However, the PPT document does actually exist. Could the issue lie in my previous line ?
I have set the relevant reference, Microsoft Powerpoint 14.0 Object Library