Copy an object from Excel and paste to Powerpoint

A

Aaron

I have a graph and combo boxes that sit over .Range("L1:AD40"). When I
manually copy this range and paste special to a PP slide as an MS excel
object, I get exactly what I want. Please help to finish this code....

Sub Paste()
Dim objPPT As Object
Dim objPres As Object

ActiveWorkbook.Sheets("UTL").Range("L1:AD40").Copy

Set objPPT = CreateObject("PowerPoint.Application")
Set PPApp = GetObject(, "Powerpoint.Application")
objPPT.Visible = True
Set objPres = objPPT.presentations.Open("C:\documents and
Settings\scuap\desktop\test.ppt")

PPApp.ActiveWindow.View.GotoSlide 2
'I need to paste special as an object here but can't figure the code out?

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top