anybody able to help me copy a table of cells or graph and pasting int
a presentation in powerpoint.

Many thank

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=37452

Hello

I hope this help you
to copy a graph in a presentation

Sub insertionGraphiqueDansPowerPoint()
'activate Microsoft Powerpoint Object Library
Dim PPT As PowerPoint.Application
Dim PptDoc As PowerPoint.Presentation
Dim NbShpe As Byte

Set PPT = CreateObject("Powerpoint.Application")
PPT.Visible = True
Set PptDoc = PPT.Presentations.Open("C:\myPresentation.ppt")

ActiveSheet.ChartObjects(1).Copy 'copy first graph in active sheet
PptDoc.Slides(3).Shapes.Paste 'paste in third slide

NbShpe = PptDoc.Slides(3).Shapes.Count

With PptDoc.Slides(3).Shapes(NbShpe)
..Name = "monGraph"
..Left = 150
..Top = 100
..Height = 300
..Width = 400
End With

'PptDoc.Save
'PptDoc.Close
'PPT.Quit
End Sub


Regards ,
michel


--
michelxld
------------------------------------------------------------------------
michelxld's Profile: http://www.excelforum.com/member.php...o&userid=17367
View this thread: http://www.excelforum.com/showthread...hreadid=374527