Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-05-2012, 12:40 PM
JohnWilson JohnWilson is offline VBA code to group picture to export as one Windows 7 64bit VBA code to group picture to export as one Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,914
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Just for the record here's how to do it with an array.

Code:
Sub Group_Pic2()
Dim osld As Slide
Dim oshp As Shape
Dim x As Integer
'using a dynamic array
Dim myray() As String
Set osld = ActivePresentation.Slides(1)
ReDim myray(1 To 1)
For Each oshp In osld.Shapes
If oshp.Type = msoPicture Then
x = x + 1
myray(x) = oshp.Name
ReDim Preserve myray(1 To UBound(myray) + 1)
End If
Next oshp
'strip the empty top value
ReDim Preserve myray(1 To UBound(myray) - 1)
If UBound(myray) > 1 Then _
osld.Shapes.Range(myray()).Group
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Powerpoint automatically changing picture size when adding a picture (2010) One_Life PowerPoint 7 01-20-2012 06:57 AM
VBA code to group picture to export as one "format picture" - arrows show as no line atop picture marbeth Word 3 07-08-2011 02:16 PM
VBA code to group picture to export as one Code to export value from ComboBox ilkks Word VBA 7 05-25-2011 04:06 AM
VBA code to export individual task lists to Excel OTPM Excel Programming 0 05-24-2011 12:23 PM
How To Export A Picture From Word? abrogard Drawing and Graphics 0 08-10-2009 06:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft