EXcel VBA : Excel Macro to create table in a PowerPoint

Posted by Balaji.N.S on Stack Overflow See other posts from Stack Overflow or by Balaji.N.S
Published on 2010-08-06T14:25:17Z Indexed on 2011/03/12 8:10 UTC
Read the original article Hit count: 423

Hi friends,

My requirement is I have a Excel which contains some data. I would like to select some data from the excel and open a PowerPoint file and

Create Table in PowerPoint and populate the data in to it

Right now I have succeeded in collecting the data from excel opening a PowerPoint file through Excel VBA Code.

Code for Opening the PowerPoint from Excel.

    Set objPPT = CreateObject("Powerpoint.application")
    objPPT.Visible = True
    Dim file As String
    file = "C:\Heavyhitters_new.ppt"
    Set pptApp = CreateObject("PowerPoint.Application")
    Set pptPres = pptApp.Presentations.Open(file)

Now how do I create the table in PowerPoint from Excel and populate the data.

Timely help will be very much appreciated.

Thanks in advance,

© Stack Overflow or respective owner

Related posts about excel

Related posts about vba