Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a number of charts that are control from a main data range in excel. I have some code to write these to a number of power point slide. However, occasionally I am getting the message: shape (unknown member): invalid request. to select a shapem its view must be active My code sets the charts in a loop and then calls the same module to control the copying - which is 'Find the open powerpoint template and make it visible Set ppApp = GetObject(, "PowerPoint.Application") ppApp.Visible = True 'goto the relevant slide in the presentation Set ppSlide = ppApp.ActivePresentation.Slides(intSlideCount) ppApp.ActivePresentation.Slides(intSlideCount).Sel ect ppSlide.Select 'paste the chart ppSlide.Shapes.Paste.Select intSlideCount = intSlideCount + 1 'increase the slide count variable It is the line ppSlide.Shapes.Paste.Select that is highlighed when debug is selected. I cant understand this because it falls over on different slides. Any help anyone could offer me would be gratefully received. Many thank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Build custom charts in Excel and copy them to PowerPoint | Excel Programming | |||
Copy/Paste Charts; Define Destination of Charts in PowerPoint | Excel Programming | |||
copy Excel charts to PowerPoint and Word | Excel Programming | |||
Copy Charts from Excel worksheet to PowerPoint | Excel Programming | |||
Macro to copy Excel charts to existing Powerpoint file | Excel Programming |