F
felon182
Hi guys,
I work for a small multimedia company doing powerpoint presentations
for events here and there. In our show it generally follows a formula
of timed introduction slides (around 30 or so) then it has the body of
the show which is all manually run. The whole show is run without the
mouse and having a pointer up on the screens would be unacceptable.
So this brings me to my first question, is it possible that once the
intro slide reaches the last one that it automatically cycles back to
the first one, creating an indefinite loop until the last slide is
skipped past? I know I could do it with a clickable link and custom
show, but I am hoping for an automatic solution which doesn't involve
any human interaction.
I have a fairly good knowledge of vba, but I really don't know if you
can attach a vba event to something like:
Private Sub Slide_Activate(SlideNumber as integer)
lastIntroSlide = 30
if SlideNumber = lastIntroSlide then
activepresentation.slides(1).goto
end if
end sub
or something of the like (sorry for the crappy code
. It seems that
the VBA in Powerpoint is geared towards buttons and userforms.
The second question is to do with Access -> Powerpoint Integration. I
have designed quite a fully featured database here to automate many
aspects of the business. I also have a powerpoint userform that
automates the putting together of presentations (a job that used to
take 20 minutes each, now takes 5 minutes
My question is, however, if I wanted to pass variables from access
over to powerpoint, how would I go about it? The ideal solution would
be that all the same text boxes and fields were built in to access
instead, with powerpoint just taking all its variables from access and
displaying the final product.
Sorry for the lengthy post, I don't post to forums often, but when I
do, I make it worthwhile!
Regards,
Galen
Slide(On Enter)
Activepresentation
I work for a small multimedia company doing powerpoint presentations
for events here and there. In our show it generally follows a formula
of timed introduction slides (around 30 or so) then it has the body of
the show which is all manually run. The whole show is run without the
mouse and having a pointer up on the screens would be unacceptable.
So this brings me to my first question, is it possible that once the
intro slide reaches the last one that it automatically cycles back to
the first one, creating an indefinite loop until the last slide is
skipped past? I know I could do it with a clickable link and custom
show, but I am hoping for an automatic solution which doesn't involve
any human interaction.
I have a fairly good knowledge of vba, but I really don't know if you
can attach a vba event to something like:
Private Sub Slide_Activate(SlideNumber as integer)
lastIntroSlide = 30
if SlideNumber = lastIntroSlide then
activepresentation.slides(1).goto
end if
end sub
or something of the like (sorry for the crappy code
. It seems thatthe VBA in Powerpoint is geared towards buttons and userforms.
The second question is to do with Access -> Powerpoint Integration. I
have designed quite a fully featured database here to automate many
aspects of the business. I also have a powerpoint userform that
automates the putting together of presentations (a job that used to
take 20 minutes each, now takes 5 minutes
My question is, however, if I wanted to pass variables from access
over to powerpoint, how would I go about it? The ideal solution would
be that all the same text boxes and fields were built in to access
instead, with powerpoint just taking all its variables from access and
displaying the final product.
Sorry for the lengthy post, I don't post to forums often, but when I
do, I make it worthwhile!
Regards,
Galen
Slide(On Enter)
Activepresentation