VBA Code works in PERSONAL but not in other excel sheets

[Angribob]

Hi All,
I hope someone can help me with this as I am getting frustrated!
The following code works in my excel personal workbook but not when I transfer it to another workbook. Do I need a different code to access Powerpoint when not in Personal?
Many thanks,
bob

Public Function opendash(x As Integer)

Dim DASHBOARDS(1 To 3) As String

DASHBOARDS(1) = Location
DASHBOARDS(2) = Location
DASHBOARDS(3) = Location

Dim ppt As PowerPoint.Application
Set ppt = New PowerPoint.Application
ppt.Visible = True
ppt.Presentations.Open Filename:=DASHBOARDS(x)

End Function

 

[Angribob]

Oh yeah i get the following error message:

Compile error:

User-defined type not defined

Thanks again

 

[VoG]

In the VBE, Tools > References and tick Microsoft Powerpoint x.x Object Library.

 

[Angribob]

Great thanks!

I now remember doing that once-upon-a-time ago for my personal workbook

cheers,

Bob