![]() |
|
#1
|
|||
|
|||
![]()
See if this does it:
Sub ImportABunch() ' based on code from pptfaq Dim SW As Long Dim SH As Long Dim strTemp As String Dim strPath As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As Shape Dim iCount As Integer ' Edit these to suit: strPath = "c:\Users\John\Desktop\Pics\" strFileSpec = "*.png" SH = ActivePresentation.PageSetup.SlideHeight SW = ActivePresentation.PageSetup.SlideWidth strTemp = Dir(strPath & strFileSpec) Do While strTemp <> "" Set oSld = ActivePresentation.Slides.Add(ActivePresentation.S lides.Count + 1, ppLayoutBlank) iCount = iCount + 1 Set oPic = oSld.Shapes.AddPicture(FileName:=strPath & strTemp, _ LinkToFile:=msoFalse, _ SaveWithDocument:=msoTrue, _ Left:=0, _ Top:=0, _ Width:=msoTrue, _ Height:=msoTrue) 'reset height to a 150points less than slide height With oPic .LockAspectRatio = msoTrue .Height = SH - 150 .Left = (SW - oPic.Width) / 2 .Top = 100 End With ' Get the next file that meets the spec and go round again strTemp = Dir Loop If MsgBox("I added " & iCount & " Images." & vbCrLf & "Would you like to delete the files? This cannot be reversed.", vbYesNo) = vbYes Then Kill strPath & "*png""" End If End Sub based on code from here: http://www.pptfaq.com/FAQ00352_Batch..._per_slide.htm |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ue418 | Excel Programming | 5 | 10-28-2017 12:52 PM |
Import from .CUB files in MS Access | vamsikrishnad | Office | 0 | 12-30-2014 03:19 AM |
Import msg-files to Outlook | Jeff10 | Outlook | 0 | 01-19-2013 10:56 AM |
![]() |
TallKewlOnez | Excel Programming | 1 | 04-09-2012 05:19 PM |
How might I group a bunch of text boxes without getting a space around the edge? | Augusta | PowerPoint | 0 | 08-25-2011 01:42 AM |