Call a .pps from excel

[Qroozn]

How can i call a powerpoint show to open from an excel macro.

I have tried using
microsoftappl.xlpowerpoint

or something similar... but it just opens a new presentation.

TIA

 

[brettvba]

as far as code is concerned

i found this but I don't know what its for
.msoConditionFileTypePowerPointPresentations
that might have something remotely to do with it??

 

[Qroozn]

Thanks for the hyperlink idea.

the code i now have is
'j1 has got the hyperlink address'

Range("J1").Select
Selection.Hyperlinks(1).Follow window:=False, AddHistory:=True
Application.WindowState = xlMaximized

the problem is that is using the web toolbar.
and i am seeing all the powerpoint toolbars instead of a full screen(as compared to when you normally run a .pps file.)

this will surfice for now. thanks for everyones assistance. But i never say no too more guidance. A little bit of knowledge is a dangerous thing.

 

[brettvba]

is there code to maximise the window
goto browse/fullscreen

 

[Ivan F Moala]

If you must run via code then
Set a reference to the powerpoint obl

Code;

<pre/>
Sub Run_PPS()

Dim ppApp As PowerPoint.Presentation

Set ppApp = GetObject("C:Program FilesMicrosoft OfficeOffice1033Overview.pps")
ppApp.SlideShowSettings.Run

End Sub
</pre>