Using VBA, Goto URL, close presentation.

[avfc4me]

I need the very last bullet in a presentation to
1. Open Internet Explorer to a set page (http://www.google.com, for example)
2. close the presentation

any advice? I need it to close the presentation because in slideshow mode,
if you just add an html link, the web browser opens but it opens BEHIND the
powerpoint slideshow and you can't go fill out the web form.

Anyone with any hints on how to make this work? I fiddled with VBA about a
year ago and with the help of the people here I got done what I needed
to...and now I've forgotten everything I learned.

 

[vindys]

Hi,

Write a macro
Sub GoToUrlEndingShow()

For i = 1 To Application.SlideShowWindows.Count
With Application.SlideShowWindows(i)
If .Presentation.Name = "Presentation1" Then
.View.Exit
End If
End With
Next i
ActivePresentation.FollowHyperlink _
Address:="http://google.com", _
NewWindow:=True, AddHistory:=True
End Sub

Change your presentation name and url as per your need.
Also set the actionsettings for your text for run this macro when text is
clicked so that the text click will call this macro.

Thanks,
Vindys

 

[Shyam Pillai]

In addition to Vindy's code. The top most slideshow window index is always
1. So SlideShowWindows(1).Exit will terminate the slide show window on top.

--
Regards,
Shyam Pillai

Animation Carbon: Copy/Paste/Share animation libraries.
www.animationcarbon.com

 

[vindys]

Shyam,

I have doubt about this. I feel the show which started most recently becomes
index as 1. Earlier show becomes 2, 3 etc. And this doesnt matter which show
is at the top. This is how I see in PPT 2003, don't know whether its not the
supposed way.

Thanks,
Vindys

 

[Shyam Pillai]

Hi Vindy,
The most recently started presentation will be 1 is the same as saying the
top most slideshow window index is always 1 since the most recently started
show will be the topmost slideshow window.

Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org/iiw.htm

 

[vindys]

Ya Shyam,

But I said about a corner case when I start two shows A and B. So
SlideShowWindows(1) will be B. After this in between I switch to slideshow A
and while i am on slideshow A, SlideShowWindows(1) is still B.