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  

macro to control other programs



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2008, 05:23 PM posted to microsoft.public.powerpoint
theintern
external usenet poster
 
Posts: 58
Default macro to control other programs

I need a macro in powerpoint, called CreateShow, that will run macros in
Project, called ImportAll, TwoWeeks, OneWeek. Is there a way to do this?
I've read a bit in the help file, but it's not enough code to actually get me
there, or to convince me this can actually be done. Also, within the
ImportAll macro, I it to run a macro in Access, called TriFilter2, a shortcut
to which is on my desktop (if that helps any).

thanks
scott
  #2  
Old July 8th, 2008, 07:25 PM posted to microsoft.public.powerpoint
theintern
external usenet poster
 
Posts: 58
Default macro to control other programs

Here is my code with comments where i need additional code. Any help would
be so much appreciated.

Sub CreateShow()
'Run ImportAll in Project
ActivePresentation.Slides(1).Select
ActiveWindow.View.Paste
'Run TwoWeeks in Project
ActivePresentation.Slides(2).Select
ActiveWindow.View.Paste
'Run OneWeek in Project
ActivePresentation.Slides(3).Select
ActiveWindow.View.Paste
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoFalse
.ShowWithNarration = msoTrue
.ShowWithAnimation = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.RGB = RGB(Red:=255, Green:=0, Blue:=0)
.Run
End With
'SlideShowWindows(Index:=1).View.Exit

End Sub

"theintern" wrote:

I need a macro in powerpoint, called CreateShow, that will run macros in
Project, called ImportAll, TwoWeeks, OneWeek. Is there a way to do this?
I've read a bit in the help file, but it's not enough code to actually get me
there, or to convince me this can actually be done. Also, within the
ImportAll macro, I it to run a macro in Access, called TriFilter2, a shortcut
to which is on my desktop (if that helps any).

thanks
scott

  #3  
Old July 8th, 2008, 08:41 PM posted to microsoft.public.powerpoint
Steve Rindsberg
external usenet poster
 
Posts: 9,366
Default macro to control other programs

In article , Theintern wrote:
Here is my code with comments where i need additional code. Any help would
be so much appreciated.


By "Project" do you mean a macro in MS Project or something entirely different?

If it's MS Project related, ask also in the appropriate newsgroup for Project, as
the code for launching its macros from an external app is likely to be peculiar to
Project, but the same no matter where you're doing it FROM.


Sub CreateShow()
'Run ImportAll in Project
ActivePresentation.Slides(1).Select
ActiveWindow.View.Paste
'Run TwoWeeks in Project
ActivePresentation.Slides(2).Select
ActiveWindow.View.Paste
'Run OneWeek in Project
ActivePresentation.Slides(3).Select
ActiveWindow.View.Paste
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoFalse
.ShowWithNarration = msoTrue
.ShowWithAnimation = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.RGB = RGB(Red:=255, Green:=0, Blue:=0)
.Run
End With
'SlideShowWindows(Index:=1).View.Exit

End Sub

"theintern" wrote:

I need a macro in powerpoint, called CreateShow, that will run macros in
Project, called ImportAll, TwoWeeks, OneWeek. Is there a way to do this?
I've read a bit in the help file, but it's not enough code to actually get me
there, or to convince me this can actually be done. Also, within the
ImportAll macro, I it to run a macro in Access, called TriFilter2, a shortcut
to which is on my desktop (if that helps any).

thanks
scott



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


  #4  
Old July 8th, 2008, 09:51 PM posted to microsoft.public.powerpoint
theintern
external usenet poster
 
Posts: 58
Default macro to control other programs

Yes, I mean Microsoft Project. Do you have any idea how to? I'll also post
this in the project section.

thanks
scott

"Steve Rindsberg" wrote:

In article , Theintern wrote:
Here is my code with comments where i need additional code. Any help would
be so much appreciated.


By "Project" do you mean a macro in MS Project or something entirely different?

If it's MS Project related, ask also in the appropriate newsgroup for Project, as
the code for launching its macros from an external app is likely to be peculiar to
Project, but the same no matter where you're doing it FROM.


Sub CreateShow()
'Run ImportAll in Project
ActivePresentation.Slides(1).Select
ActiveWindow.View.Paste
'Run TwoWeeks in Project
ActivePresentation.Slides(2).Select
ActiveWindow.View.Paste
'Run OneWeek in Project
ActivePresentation.Slides(3).Select
ActiveWindow.View.Paste
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoFalse
.ShowWithNarration = msoTrue
.ShowWithAnimation = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.RGB = RGB(Red:=255, Green:=0, Blue:=0)
.Run
End With
'SlideShowWindows(Index:=1).View.Exit

End Sub

"theintern" wrote:

I need a macro in powerpoint, called CreateShow, that will run macros in
Project, called ImportAll, TwoWeeks, OneWeek. Is there a way to do this?
I've read a bit in the help file, but it's not enough code to actually get me
there, or to convince me this can actually be done. Also, within the
ImportAll macro, I it to run a macro in Access, called TriFilter2, a shortcut
to which is on my desktop (if that helps any).

thanks
scott



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



  #5  
Old July 9th, 2008, 03:33 AM posted to microsoft.public.powerpoint
Steve Rindsberg
external usenet poster
 
Posts: 9,366
Default macro to control other programs

In article , Theintern wrote:
Yes, I mean Microsoft Project. Do you have any idea how to?


Not a clue, I'm a afraid. I don't know that I've ever even seen it alive on a computer
screen.

I'll also post
this in the project section.


Also, have a look he

http://www.veign.com/code-view.php?type=app&codeid=60

This is Excel-specific. The code to run macros within a PPT is similar. Maybe with
some fiddling you can get it to fly in Project as well.

Good luck!


thanks
scott

"Steve Rindsberg" wrote:

In article , Theintern wrote:
Here is my code with comments where i need additional code. Any help would
be so much appreciated.


By "Project" do you mean a macro in MS Project or something entirely different?

If it's MS Project related, ask also in the appropriate newsgroup for Project, as
the code for launching its macros from an external app is likely to be peculiar to
Project, but the same no matter where you're doing it FROM.


Sub CreateShow()
'Run ImportAll in Project
ActivePresentation.Slides(1).Select
ActiveWindow.View.Paste
'Run TwoWeeks in Project
ActivePresentation.Slides(2).Select
ActiveWindow.View.Paste
'Run OneWeek in Project
ActivePresentation.Slides(3).Select
ActiveWindow.View.Paste
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoFalse
.ShowWithNarration = msoTrue
.ShowWithAnimation = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.RGB = RGB(Red:=255, Green:=0, Blue:=0)
.Run
End With
'SlideShowWindows(Index:=1).View.Exit

End Sub

"theintern" wrote:

I need a macro in powerpoint, called CreateShow, that will run macros in
Project, called ImportAll, TwoWeeks, OneWeek. Is there a way to do this?
I've read a bit in the help file, but it's not enough code to actually get me
there, or to convince me this can actually be done. Also, within the
ImportAll macro, I it to run a macro in Access, called TriFilter2, a shortcut
to which is on my desktop (if that helps any).

thanks
scott


-----------------------------------------
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


All times are GMT +1. The time now is 11:07 PM.


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