User-Defined Type Not Defined compile error when creating PowerPoint using VBA in Excel

[MsManzy]

I am using Microsoft Excel 2010 and Microsoft VBA 7.0 on my system. I would like to eventually create a PowerPoint and insert charts generated in the Excel workbook. In the meantime, I cannot get the basic PowerPoint created.

The line in red is highlighted blue when the compile error "User-defined type not defined" message box appears.

Public Sub TryAgain()

Dim myPowerPoint As PowerPoint.Application
'
' do nothing for now
'​

End Sub

​

I have set the references such that Microsoft Project 14.0 Object Library is indeed checked. The Excel file only contains this code in a module. All sheets are blank. Nothing else is written yet.

I am probably missing something, so direction would be most helpful. If more information is required, please let me know.

 

[Fluff]

Hello MsManzy
Have you set the reference for Microsoft PowerPoint 14.0 Object Library?

 

[MsManzy]

Yes, I have set the reference. Any ideas? I have tried again in a brand new workbook and it still doesn't work.

 

[Fluff]

Hiya
The only time I have come across that error is when a reference has not been set.
The only other thing I can suggest is to try a repair, go to Control Panel\All Control Panel Items\Programs and Features then right click on Microsoft Office & select repair
Depending on the type of installation, you may need a system disc

 

[MsManzy]

I did right-click on my Microsoft Office program in control panel, and there was not an option to repair. Thanks for the help. I did not get it working, but I will try again with a brand new workbook.