Does Power Point 2003 recognize AutoExec in VBA?

I am new to VBA and OOP (but did a bit of sequential
programing). I am not sure if I am having a problem with
VBA or with Power Point. I have an application object
defined in a Class1 module with events, say:

Public WithEvents App as Application

I have a subroutine doing things I wanted to do in a
different module, say

Private Sub App_SlideShowNextSlide(ByVal Wn As
SlideShowWindow)
some code here, tested, works
End Sub

Then, I tried to instantiate by:

Dim X as New Class1
Sub AutoExec()
Set X.App = Application
End Sub

I wanted my code to work behind the scene during slide
show and react to every slide change. It doesn't work.
Am I abusing VBA or PowerPoint or both?

Adam

In article <1610001c416d5$04b89fb0$(E-Mail Removed)>, Adam wrote:
> Does Power Point 2003 recognize AutoExec in VBA?

No, but it will run Sub Auto_Open in an add-in (but not in a PPT) when the
add-in loads.

This should help:

Make PPT respond to events
http://www.rdpslides.com/pptfaq/FAQ00004.htm

>
> I am new to VBA and OOP (but did a bit of sequential
> programing). I am not sure if I am having a problem with
> VBA or with Power Point. I have an application object
> defined in a Class1 module with events, say:
>
> Public WithEvents App as Application
>
> I have a subroutine doing things I wanted to do in a
> different module, say
>
> Private Sub App_SlideShowNextSlide(ByVal Wn As
> SlideShowWindow)
> some code here, tested, works
> End Sub
>
> Then, I tried to instantiate by:
>
> Dim X as New Class1
> Sub AutoExec()
> Set X.App = Application
> End Sub
>
> I wanted my code to work behind the scene during slide
> show and react to every slide change. It doesn't work.
> Am I abusing VBA or PowerPoint or both?
>
> Adam
>

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com

Thank you Steve, this explains it. Also, thanks for the
links. Good reading there.

Just because of curiosity: why Microsoft allows AutoExec
in Word, Excel and I guess in Outlook and Access but not
in PowerPoint?

Adam
>-----Original Message-----
>
>
>In article <1610001c416d5$04b89fb0$(E-Mail Removed)>,
Adam wrote:
>> Does Power Point 2003 recognize AutoExec in VBA?
>
>No, but it will run Sub Auto_Open in an add-in (but not
in a PPT) when the
>add-in loads.
>
>This should help:
>
>Make PPT respond to events
>http://www.rdpslides.com/pptfaq/FAQ00004.htm
>
>>
>> I am new to VBA and OOP (but did a bit of sequential
>> programing). I am not sure if I am having a problem
with
>> VBA or with Power Point. I have an application object
>> defined in a Class1 module with events, say:
>>
>> Public WithEvents App as Application
>>
>> I have a subroutine doing things I wanted to do in a
>> different module, say
>>
>> Private Sub App_SlideShowNextSlide(ByVal Wn As
>> SlideShowWindow)
>> some code here, tested, works
>> End Sub
>>
>> Then, I tried to instantiate by:
>>
>> Dim X as New Class1
>> Sub AutoExec()
>> Set X.App = Application
>> End Sub
>>
>> I wanted my code to work behind the scene during slide
>> show and react to every slide change. It doesn't work.
>> Am I abusing VBA or PowerPoint or both?
>>
>> Adam
>>
>
>--
>Steve Rindsberg, PPT MVP
>PPT FAQ: www.pptfaq.com
>PPTools: www.pptools.com
>
>.
>

In article <13c7d01c41779$c2ecff90$(E-Mail Removed)>, Adam wrote:
> Thank you Steve, this explains it. Also, thanks for the
> links. Good reading there.
>
> Just because of curiosity: why Microsoft allows AutoExec
> in Word, Excel and I guess in Outlook and Access but not
> in PowerPoint?

There are a couple of us here who've been wondering the same thing since they
introduced VBA in PowerPoint 97. You should see Brian - he's pulled almost all
his hair out already!

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com

[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

If you (or anyone else reading this message) can think of a compelling
reason why PowerPoint should allow AutoExec (hint: "Because Word and Excel
do" is not a compelling reason), don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

It's VERY important that, for EACH wish, you describe in detail, WHY it is
important TO YOU that your product suggestion be implemented. A good wish
submssion includes WHAT scenario, work-flow, or end-result is blocked by
not having a specific feature, HOW MUCH time and effort ($$$) is spent
working around a specific limitation of the current product, etc. Remember
that Microsoft receives THOUSANDS of product suggestions every day and we
read each one but, in any given product development cycle, there are ONLY
sufficient resources to address the ones that are MOST IMPORTANT to our
customers so take the extra time to state your case as CLEARLY and
COMPLETELY as possible so that we can FEEL YOUR PAIN.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

John and asks why I would need it.

I am new to VBA. I did a bit of sequential programming
some years ago, then did other things, and now I am trying
to gain an intuitive feeling about object oriented
programming similar to one I have in sequential. VBA is
what I already have on my machine.

I tend to learn while working. Thus, I though I will write
a code that would put the time elapsed since the beginning
of the PPT show on each current slide in the slide show
view, a very useful thing for a presenter. I wanted to
auto instantiate my with events object, such that there is
nothing else to be done to have it working. At the moment
I have to run the instantiating routine manually before
starting the slide show. That's it.

Now, I know there are routines out there that can do this.
But if I buy one, I will not learn anything.

Adam

>-----Original Message-----
>[CRITICAL UPDATE - Anyone using Office 2003 should
install the critical
>update as soon as possible. From PowerPoint,
choose "Help -> Check for
>Updates".]
>
>Hello,
>
>If you (or anyone else reading this message) can think of
a compelling
>reason why PowerPoint should allow AutoExec
(hint: "Because Word and Excel
>do" is not a compelling reason), don't forget to send
your feedback (in
>YOUR OWN WORDS, please) to Microsoft at:
>
>http://register.microsoft.com/mswish/suggestion.asp
>
>It's VERY important that, for EACH wish, you describe in
detail, WHY it is
>important TO YOU that your product suggestion be
implemented. A good wish
>submssion includes WHAT scenario, work-flow, or end-
result is blocked by
>not having a specific feature, HOW MUCH time and effort
($$$) is spent
>working around a specific limitation of the current
product, etc. Remember
>that Microsoft receives THOUSANDS of product suggestions
every day and we
>read each one but, in any given product development
cycle, there are ONLY
>sufficient resources to address the ones that are MOST
IMPORTANT to our
>customers so take the extra time to state your case as
CLEARLY and
>COMPLETELY as possible so that we can FEEL YOUR PAIN.
>
>IMPORTANT: Each submission should be a single suggestion
(not a list of
>suggestions).
>
>John Langhans
>Microsoft Corporation
>Supportability Program Manager
>Microsoft Office PowerPoint for Windows
>Microsoft Office Picture Manager for Windows
>
>For FAQ's, highlights and top issues, visit the Microsoft
PowerPoint
>support center at:
http://support.microsoft.com/default.aspx?pr=ppt
>Search the Microsoft Knowledge Base at:
>http://support.microsoft.com/default.aspx?pr=kbhowto
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of any included script samples are subject to the
terms specified at
>http://www.microsoft.com/info/cpyright.htm
>
>.
>

Hi Adam,

> John and asks why I would need it.

And thanks for answering. But if you want to see your suggestions implemented
in PowerPoint, it's important to enter them here:

http://register.microsoft.com/mswish/suggestion.asp

Please take a few seconds to do that - just copy and paste your original answer
into the form there if you like. Thanks!

>
> I am new to VBA. I did a bit of sequential programming
> some years ago, then did other things, and now I am trying
> to gain an intuitive feeling about object oriented
> programming similar to one I have in sequential. VBA is
> what I already have on my machine.
>
> I tend to learn while working. Thus, I though I will write
> a code that would put the time elapsed since the beginning
> of the PPT show on each current slide in the slide show
> view, a very useful thing for a presenter. I wanted to
> auto instantiate my with events object, such that there is
> nothing else to be done to have it working. At the moment
> I have to run the instantiating routine manually before
> starting the slide show. That's it.
>
> Now, I know there are routines out there that can do this.
> But if I buy one, I will not learn anything.
>
> Adam
>
> >-----Original Message-----
> >[CRITICAL UPDATE - Anyone using Office 2003 should
> install the critical
> >update as soon as possible. From PowerPoint,
> choose "Help -> Check for
> >Updates".]
> >
> >Hello,
> >
> >If you (or anyone else reading this message) can think of
> a compelling
> >reason why PowerPoint should allow AutoExec
> (hint: "Because Word and Excel
> >do" is not a compelling reason), don't forget to send
> your feedback (in
> >YOUR OWN WORDS, please) to Microsoft at:
> >
> >http://register.microsoft.com/mswish/suggestion.asp
> >
> >It's VERY important that, for EACH wish, you describe in
> detail, WHY it is
> >important TO YOU that your product suggestion be
> implemented. A good wish
> >submssion includes WHAT scenario, work-flow, or end-
> result is blocked by
> >not having a specific feature, HOW MUCH time and effort
> ($$$) is spent
> >working around a specific limitation of the current
> product, etc. Remember
> >that Microsoft receives THOUSANDS of product suggestions
> every day and we
> >read each one but, in any given product development
> cycle, there are ONLY
> >sufficient resources to address the ones that are MOST
> IMPORTANT to our
> >customers so take the extra time to state your case as
> CLEARLY and
> >COMPLETELY as possible so that we can FEEL YOUR PAIN.
> >
> >IMPORTANT: Each submission should be a single suggestion
> (not a list of
> >suggestions).
> >
> >John Langhans
> >Microsoft Corporation
> >Supportability Program Manager
> >Microsoft Office PowerPoint for Windows
> >Microsoft Office Picture Manager for Windows
> >
> >For FAQ's, highlights and top issues, visit the Microsoft
> PowerPoint
> >support center at:
> http://support.microsoft.com/default.aspx?pr=ppt
> >Search the Microsoft Knowledge Base at:
> >http://support.microsoft.com/default.aspx?pr=kbhowto
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >Use of any included script samples are subject to the
> terms specified at
> >http://www.microsoft.com/info/cpyright.htm
> >
> >.
> >
>


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com