Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default POWERPOINT SHEETS IN EXCEL MACROS

How can I combine powerpoint sheets in excel macros with some wait time on
the screen ?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default POWERPOINT SHEETS IN EXCEL MACROS

Not sure what you need, but look he

http://groups.google.com/group/micro...a144dca9d2537c

"Vijay Kotian" wrote:

How can I combine powerpoint sheets in excel macros with some wait time on
the screen ?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default POWERPOINT SHEETS IN EXCEL MACROS

To have a better view for my excel macro i would like to add 2-3 powerpoint
slides ...
I would like to open powerpoint file and do the slideshow and close
powerpoint and then run normal excel macro.
If you can help me with it.. I have tried with the address given by you but
has limited help to me.

Someone gave me the following macros but i am getting a error message while
running excel macro after opening ppt file


Dim objPPT As Object
Dim objPres As Object

Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True
Set objPres = objPPT.presentations.Open("D:\CODECHANGE\CODE CHANGE.ppt")

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

Regards,
Vijay Kotian


"JLGWhiz" wrote:

Not sure what you need, but look he

http://groups.google.com/group/micro...a144dca9d2537c

"Vijay Kotian" wrote:

How can I combine powerpoint sheets in excel macros with some wait time on
the screen ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Powerpoint slides to be used in excel macros Vijay Kotian Excel Discussion (Misc queries) 1 November 30th 06 07:44 AM
How do I transfer data from multiple excel sheets to powerpoint Gordon McDougall Excel Discussion (Misc queries) 1 January 3rd 06 09:16 PM
applying rules to Excel Sheets using Macros [email protected] Excel Programming 1 May 11th 05 02:21 PM
Presentation of my macros -how to in powerpoint chandrans Excel Programming 1 November 6th 04 11:39 AM
A good book on using Powerpoint VBA to drive macros in Excel ? Charles Jordan Excel Programming 0 April 23rd 04 07:06 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"