Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Excel & Powerpoint Copy & paste | Excel Discussion (Misc queries) | |||
Excel to Powerpoint - copy/paste text box | Excel Programming | |||
VB script in Excel object in Powerpoint (Urgent) | Excel Discussion (Misc queries) | |||
excel to powerpoint- paste a range | Excel Programming | |||
Importing Excel Object in Powerpoint | Excel Discussion (Misc queries) |