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