LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default POWERPOINT IN EXCEL

If you are talking about a PPT presentaiton embedded in Excel, displayed as
an icon, use code like


Dim WS As Worksheet
Dim OLEObj As OLEObject
Dim S As String
Dim N As Long

Set WS = ActiveSheet 'change if required
For Each OLEObj In WS.OLEObjects
If InStr(1, OLEObj.SourceName, "PowerPoint") 0 Then
OLEObj.Verb xlVerbPrimary
Exit For
End If
Next OLEObj


If you have named the object, you can use code like

Dim WS As Worksheet
Dim OLEObj As OLEObject
Dim PPTName As String

Set WS = ActiveSheet '<<< change if required
PPTName = "PPT1" '<<< change if required
Set OLEObj = WS.OLEObjects(PPTName)
OLEObj.Verb xlVerbPrimary



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Glenn" wrote in message
...
Is there anyway to write a micro that when it starts plays a powerpoint
slide
show?



 
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 IN EXCEL Kari J Keinonen[_2_] Excel Programming 0 January 16th 07 12:13 AM
Excel to powerpoint srinivas[_2_] Excel Programming 0 September 21st 06 10:48 AM
excel to powerpoint confused Excel Worksheet Functions 1 October 5th 05 05:40 PM
Excel - Powerpoint Mestrella31 Excel Programming 0 October 18th 04 06:53 PM
Excel to powerpoint toddmbright Excel Programming 1 May 29th 04 03:03 AM


All times are GMT +1. The time now is 01:53 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"