AutoExec

[Adam]

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

 

[Steve Rindsberg]

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

 

[adam]

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

 

[Steve Rindsberg]

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!

 

[John Langhans [MSFT]]

[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

 

[Adam]

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

.

 

[Steve Rindsberg]

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

.