Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pasting to PowerPoint (2003)

    How can I efficiently copy and paste a chart into a PowerPoint presentation? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pasting to PowerPoint (2003)

    I don't think there's a special secret. Simply select the chart in Excel, press Ctrl+C to copy, switch to PowerPoint and press Ctrl+V to paste.
    Or if you want to link the chart, select Edit | Paste Special..., tick the check box Paste Link, then click OK.

    Or did you actually want to ask something different?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting to PowerPoint (2003)

    Doh! I meant using code?! Soz...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pasting to PowerPoint (2003)

    Do you want to paste into an existing presentation?
    If so, it it already open, or should the macro open it?
    And should it be pasted into an existing slide, or should the macro create a new slide?

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting to PowerPoint (2003)

    Hi. I want to create a new slide within an existing presentation, but not necessarily to open it. Thanks, Andy.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pasting to PowerPoint (2003)

    You can't manipulate a presentation without opening it.

    See the code in the attached text file. You must set a reference to the Microsoft PowerPoint 11.0 Object Library in Tools | References... before running the code.
    The code will prompt you to select the presentation. It will copy the first chart on the active sheet into a new slide in the presentation, then save and close the presentation.
    Attached Files Attached Files

  7. #7
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting to PowerPoint (2003)

    Top man. PowerPoint has a very cumbersome object model. Andy.

Posting Permissions

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