![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#3
|
|||
|
|||
|
Thank you John Wilson. Your method worked and positioned the chart on the page perfectly.
One more question if you know? The Title of the chart is positioned at the bottom of the page and the Title itself is left as "Click to add title". Do you know another method to position the title correctly at the top? Perhaps this is another change from Office 2003 to Office 2007? Any tips are appreciated. Sub UpdateGraph() Dim SheetNum As Integer SheetNum = ActiveWorkbook.Worksheets.Count Dim PPapt As PowerPoint.Application Dim PPpres As PowerPoint.Presentation Dim rngNewRange As Excel.Range Dim Sh As Shape Set oPPTApp = CreateObject("PowerPoint.Application") oPPTApp.Visible = msoTrue Set PPpres = oPPTApp.Presentations.Open("C:\Presentation1.ppt") Dim SubclassArray(100, 2) As String For y% = 1 To 99 SubclassArray(y%, 1) = Worksheets("List").Cells(y% + 2, 5).Value SubclassArray(y%, 2) = Worksheets("List").Cells(y% + 2, 6).Value Next For x% = 1 To 100 Worksheets("OUT").Activate Worksheets("OUT").Range("D2").Value = SubclassArray(x%, 2) Set rngNewRange = Worksheets("OUT").Range("B2:L41") rngNewRange.Select rngNewRange.Copy With PPpres.Slides(x%).Shapes.PasteSpecial(ppPasteEnhan cedMetafile) .Height = 410 .Width = 630 .Left = 40 .Top = 75 End With ' PPpres.Slides(x%).Shapes.PasteSpecial ppPasteEnhancedMetafile ' PPpres.Slides(x%).Shapes(2).Height = 450 ' PPpres.Slides(x%).Shapes(2).Width = 654 ' PPpres.Slides(x%).Shapes(2).Left = 60 ' PPpres.Slides(x%).Shapes(2).Top = 100 Dim HeaderText As String HeaderText = "Class: " & SubclassArray(x%, 1) PPpres.Slides(x%).Shapes(1).TextFrame.TextRange.Te xt = HeaderText Next End Sub |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
slide image wont copy with text to new slide
|
lewis.mulhollen | PowerPoint | 1 | 12-17-2011 03:17 AM |
| PP 07 Random Chart Dissappearing in Slide Show | DKY | PowerPoint | 0 | 11-02-2011 04:38 AM |
| Maintaining a shrunken object from slide to slide | Straitsfan | PowerPoint | 0 | 05-18-2011 01:04 PM |
| What slide attribute can I use in VBA to detect hidden slide? | mikel401 | PowerPoint | 1 | 02-22-2011 11:13 AM |
| Need to make a rotating slide presentation | squatch97402 | PowerPoint | 0 | 12-03-2010 10:26 PM |