A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VBA with Powerpoint



 
 
Thread Tools Display Modes
  #1  
Old January 16th, 2005, 04:11 PM
Desmond
external usenet poster
 
Posts: n/a
Default VBA with Powerpoint

There are lots of books for VBA with word access and ecel, but none for
powerpoint.

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups.

Desmond.

  #2  
Old January 16th, 2005, 07:06 PM
TAJ Simmons
external usenet poster
 
Posts: n/a
Default

Desmond,

To the best of my knowledge, this is the only book specifically about vba
and powerpoint

Powerful powerpoint
http://www.loyola.edu/education/PowerfulPowerPoint/

more reading

Where can I learn more about VBA programming in PowerPoint?
http://www.rdpslides.com/pptfaq/FAQ00032.htm

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free powerpoint templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com

"Desmond" wrote in message
...
There are lots of books for VBA with word access and ecel, but none for
powerpoint.

I need to controll powerpoint by forcing it to jump to specified pages
using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups.

Desmond.



  #3  
Old January 16th, 2005, 08:01 PM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups


Except this one. But you got lucky. ;-)

Sure, this is possible. Let's start with how far you've gotten and where you
need to be.

Have you already worked out how to fire off an instance of PPT from VB and
control it? If so, all you need is a few lines of code to add to your project.

Next, do you need to go to a specific slide in slide show view or in regular
edit view?


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


  #4  
Old January 16th, 2005, 10:45 PM
Desmond
external usenet poster
 
Posts: n/a
Default

Thanks for your help. about 3 years ago I had do a project using Access. for
a catalouge company. a stats retreval. I used VB to open a word document and
create a large table of data. A long time ago and I still have the original
code somewhere. To create an instance of the object and use it. I have never
done this in PPT. All I want is a mini graphical song board of tunes and by
clicking on the correct one get powerpoint (all ready running) to jump to 101
and get the windows focus (for key and mouse input back in control)

Thanks

Desmond


"Steve Rindsberg" wrote:

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups


Except this one. But you got lucky. ;-)

Sure, this is possible. Let's start with how far you've gotten and where you
need to be.

Have you already worked out how to fire off an instance of PPT from VB and
control it? If so, all you need is a few lines of code to add to your project.

Next, do you need to go to a specific slide in slide show view or in regular
edit view?


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



  #5  
Old January 17th, 2005, 01:24 AM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

In article , Desmond wrote:
Thanks for your help. about 3 years ago I had do a project using Access. for
a catalouge company. a stats retreval. I used VB to open a word document and
create a large table of data. A long time ago and I still have the original
code somewhere. To create an instance of the object and use it. I have never
done this in PPT. All I want is a mini graphical song board of tunes and by
clicking on the correct one get powerpoint (all ready running) to jump to 101
and get the windows focus (for key and mouse input back in control)


Again, is Powerpoint going to be running in edit or show mode?


Thanks

Desmond

"Steve Rindsberg" wrote:

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups


Except this one. But you got lucky. ;-)

Sure, this is possible. Let's start with how far you've gotten and where you
need to be.

Have you already worked out how to fire off an instance of PPT from VB and
control it? If so, all you need is a few lines of code to add to your project.

Next, do you need to go to a specific slide in slide show view or in regular
edit view?


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





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


  #6  
Old January 17th, 2005, 04:37 PM
Desmond
external usenet poster
 
Posts: n/a
Default

Powerpoint will not be in edit mode it will be running in slide show mode. I
want to show slides 1 to 4 of a song using the kepord keys then jump to
another song which could be slides 602 to 608. There for a simple vb
aplication with 4 text boxes holding the 4 starting places could be used to
force powerpoint to the next group of slides. And regaining the focus for the
keyboard again.

Desmond.


"Steve Rindsberg" wrote:

In article , Desmond wrote:
Thanks for your help. about 3 years ago I had do a project using Access. for
a catalouge company. a stats retreval. I used VB to open a word document and
create a large table of data. A long time ago and I still have the original
code somewhere. To create an instance of the object and use it. I have never
done this in PPT. All I want is a mini graphical song board of tunes and by
clicking on the correct one get powerpoint (all ready running) to jump to 101
and get the windows focus (for key and mouse input back in control)


Again, is Powerpoint going to be running in edit or show mode?


Thanks

Desmond

"Steve Rindsberg" wrote:

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups

Except this one. But you got lucky. ;-)

Sure, this is possible. Let's start with how far you've gotten and where you
need to be.

Have you already worked out how to fire off an instance of PPT from VB and
control it? If so, all you need is a few lines of code to add to your project.

Next, do you need to go to a specific slide in slide show view or in regular
edit view?


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





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



  #7  
Old January 18th, 2005, 12:13 AM
Brian Reilly, MS MVP
external usenet poster
 
Posts: n/a
Default

Desmond,
We do a lot of controlling of PPT from other Office apps woithout many
problems.

Everything you are looking for is probably available from the Access
VBE, assuming you have PPT version that is exposed to events, This is
not the easiest of code to write but is also not that hard for an
experieced VB/VBA programmer.

PPT only exposes events, unlike what we are used to in other Office
apps in a funny way. See Shyam Pillai's web site, or the PPTFAQ.com
page and search on Events to see how to do this. You could also google
on PowerPoint Events (I would bet) to get may links.

Brian Reilly, PowerPoint MVP
  #8  
Old January 18th, 2005, 04:05 AM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

In article , Desmond wrote:
Powerpoint will not be in edit mode it will be running in slide show mode. I
want to show slides 1 to 4 of a song using the kepord keys then jump to
another song which could be slides 602 to 608. There for a simple vb
aplication with 4 text boxes holding the 4 starting places could be used to
force powerpoint to the next group of slides. And regaining the focus for the
keyboard again.


Assuming you have a reference to the PPT application in oPPTApp:

oPPTApp.ActivePresentation.SlideShowWindow.View.Go ToSlide(X)

where X is the index of the slide you want to jump to.




Desmond.

"Steve Rindsberg" wrote:

In article , Desmond wrote:
Thanks for your help. about 3 years ago I had do a project using Access. for
a catalouge company. a stats retreval. I used VB to open a word document and
create a large table of data. A long time ago and I still have the original
code somewhere. To create an instance of the object and use it. I have never
done this in PPT. All I want is a mini graphical song board of tunes and by
clicking on the correct one get powerpoint (all ready running) to jump to 101
and get the windows focus (for key and mouse input back in control)


Again, is Powerpoint going to be running in edit or show mode?


Thanks

Desmond

"Steve Rindsberg" wrote:

I need to controll powerpoint by forcing it to jump to specified pages using
a stand alone VB application. Is this possible. I have exausted all known
newsgroups

Except this one. But you got lucky. ;-)

Sure, this is possible. Let's start with how far you've gotten and where you
need to be.

Have you already worked out how to fire off an instance of PPT from VB and
control it? If so, all you need is a few lines of code to add to your project.

Next, do you need to go to a specific slide in slide show view or in regular
edit view?


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





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





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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Several Charts to a PowerPoint Presentation JRPK Links and Linking 3 April 2nd, 2005 10:02 PM
vb.net dll won't release powerpoint C Williams Powerpoint 6 January 3rd, 2005 08:07 PM
open Powerpoint main window and display a PPT file with automation David Powerpoint 0 December 6th, 2004 09:57 PM
PowerPoint to Excel link issues DrLostinExcel Powerpoint 5 November 19th, 2004 04:33 PM
Running Powerpoint Viewer 2003 inside IE TAJ Simmons Powerpoint 2 August 24th, 2004 04:25 PM


All times are GMT +1. The time now is 10:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.