Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2012, 11:18 PM
JohnWilson JohnWilson is offline Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur Windows 7 64bit Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur 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


Don't see why that doesn't work but I think I would do it like this:

Code:
Sub TestCode()
Dim objPPTApp As Object
Dim objPPPres As Object
Dim objPPSld As Object
'Open Existing PowerPoint
Set objPPTApp = CreateObject("PowerPoint.Application")
With objPPTApp
    .Visible = True
    Set objPPPres = .Presentations.Open("C:\Users\John\Documents\Test\Test.pptx")
End With
Set objPPSld = objPPPres.Slides(1)
Call addpic(objPPPres, objPPSld, "C:\Users\John\Documents\test\Pic1.jpg")
Call addpic(objPPPres, objPPSld, "C:\Users\John\Documents\test\Pic2.jpg")
End Sub

Sub addpic(opres As Presentation, osld As Slide, strPath As String)
Dim opic As Shape
Set opic = osld.Shapes.AddPicture(strPath, False, True, 1, 1, -1, -1)
With opic
.LockAspectRatio = True
.Width = 500
With opres.PageSetup
        opic.Left = (.SlideWidth \ 2) - (opic.Width \ 2)
        opic.Top = (.SlideHeight \ 2) - (opic.Height \ 2)
End With
End With
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #2  
Old 05-06-2012, 09:27 PM
CatMan CatMan is offline Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur Windows 7 32bit Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur Office 2010 32bit
Intermediate
Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur
 
Join Date: Apr 2012
Posts: 39
CatMan is on a distinguished road
Default

Hello JohnWilson again, thank your for your continued help, I really appreciate it. I ran the code you offered and am getting a type mismatch error on the line containing .addPicture. Even with this error the picture is inserted into slide 1 but then it stops. I can't figure out what is causing the mismatch, objPPTAAppa is the PowerPoint Application object, objPPPres is the specific PowerPoint file, looks like objPPSid is the ID of slide 1, that all makes sense to me, not sure what is causing the mismatch.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Title:  Why does focus fail to change to MyPic2.jpg (intermittently) after .addPictur Fail to access outlook to set the settings!!!!! Jamal NUMAN Outlook 3 04-20-2011 06:32 PM
Duration changes fail to update work effort Panteledes Project 6 05-25-2010 02:27 PM
Secondary IP address Outlook Fail-over danish.mustafa Outlook 0 03-01-2010 01:32 AM
Help with forms (shifting focus) jrh312 Word 0 11-19-2009 12:59 PM
Shortcuts Fail sussertown Outlook 0 02-16-2009 06:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.


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