Selecting Hymns Quickly

[Leonard]

I am using PowerPoint 2000 on a Church laptop. We have 800 hymns on
individual PowerPoint presentations. Our problem is if someone calls out
e.g. 365 - how can we select it quickly.

Is there any special coding or macros that can be used to speed up this
concept.

I hope I have explained enough of my problem here,

Leonard

 

[Leonard]

PS - I was thinking along the lines of some kind of text box where I would
insert the hymn number and up pops the hymn if that helps explain a little
better about where I am coming from,

Leonard

 

[David M. Marcovitz]

Here is something simple that might do the trick:

Sub PickHymnFile()
hymn = InputBox("Enter the hymn number")
hymn = hymn & ".ppt"
ActivePresentation.FollowHyperlink Address:=hymn
End Sub

This procedure will ask you to type the number of a hymn, and it will try
to link to a file with that hymn number. For example, if you type 365,
it will try to open 365.ppt.

For this to work, you must have all your hymns in files with the names as
numbers: 1.ppt, 2.ppt, 3.ppt, 4.ppt, ... You also must have the
presentation that you are running in the same directory as all the hymn
files.

I didn't include any error checking, so if you type a number for a file
that doesn't exist, it won't do anything, and you will have to click on
the button again and type a new number.

Let me know if this helps.

--David

--
David M. Marcovitz, Ph.D.
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

 

[Jamie]

As you are playing the presentation, simply type in the slide number and
press enter. It will jump to that slide automatically.

If you have hymns that take up more an one slide, you may need to print out
a list off all the slides on a seperate sheet. Click File, Print. Under
"Print What" choose "Handouts" the choose how many you want on a page.

PS...
I'm a pastor as well as a software instructor.

 

[Leonard]

Thankyou Jamie - I will take a look at all the ideas as they are presented
to me - it may take a few days before I can provide any feedback,

Leonard

 

[Leonard]

I like the sound of this idea but it is going to be a few days before I can
try any of the ideas out fully although I can experiment at home,

many thanks for your prompt input,

Leonard

 

[Chirag]

You might want to look at PowerShow add-in at
http://officeone.mvps.org/powershow/powershow.html - among other things, it
enables you to select a slide in the slide sorter view to beam that slide
through the projector. You can use this feature to quickly move to a
specific slide.

- Chirag

Shortcut Manager - Assign keyboard shortcuts to menu items and macros
http://officeone.mvps.org/ppsctmgr/ppsctmgr.html