Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Receiving error message when trying to paste OLEobject into PowerPoint from Excel

  1. #1
    Join Date
    13th May 2011
    Posts
    3

    Receiving error message when trying to paste OLEobject into PowerPoint from Excel

    Hey everyone!

    I am having some issues pasting a linked excel chart into an embedded PowerPoint. I either get an error message or PowerPoint completely shuts down. Any help is appreciated! code is as follows:

    VB:
    Sub PastingChart() 
         '
         ' PastingChart
         '
        Dim PPApp As PowerPoint.Application 
        Dim PPPres As PowerPoint.Presentation 
        Dim PPSlide As PowerPoint.Slide 
         '
        Sheets("Report").Select 
        ActiveSheet.Shapes("Object 34").Select 
        Selection.Verb Verb:=3 
        Set PPApp = GetObject(, "Powerpoint.Application") 
        Set PPPres = PPApp.ActivePresentation 
        PPApp.ActiveWindow.ViewType = ppViewSlide 
        Worksheets("May2011_Summary").Select 
        ActiveSheet.ChartObjects("Chart 1").Activate 
        ActiveChart.ChartArea.Copy 
        PPPres.Slides(2).Shapes.PasteSpecial ppPasteOLEObject, DisplayasIcon = False, , , , Link = True 
         
    End Sub 
    
    
    Last edited by cytop; June 2nd, 2011 at 04:18.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,335

    Re: Receiving error message when trying to paste OLEobject into PowerPoint from Excel

    The same initial advice as with your other post (which, incidentally, went totally unanswered by you) is to upload anonymous/cut-down copies of your workbook and presentation...

    By the way, the proper way to close code tags is [/code] ... but thanks for trying, at least. I have edited your post to correct.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    13th May 2011
    Posts
    3

    Re: Receiving error message when trying to paste OLEobject into PowerPoint from Excel

    I apologize for not attaching an anonymous/cut-down copy of my workbook. However I figured the code would suffice (thank you for updating my post). It is a very large workbook and would take me hours to get it to a point where I could upload it.

    I just need to know if the code above is possible with Excel 2007. I have researched this and it looks like 2007 does not support pasting a link to the chart, in PowerPoint, via VBA.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Copy And Paste Macro Receiving Runtime Errors
    By camcrazy08 in forum EXCEL HELP
    Replies: 3
    Last Post: September 4th, 2007, 22:29
  2. Receiving Error in code
    By Justice23 in forum EXCEL HELP
    Replies: 2
    Last Post: April 26th, 2006, 03:35

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno