PDA

View Full Version : updata e graph in ppt with excel data using vba in ppt



james1989
04-08-2012, 05:05 AM
Hi,
I have a graph in slide 4 of ppt.I have a data in sheet 3 of book1.xls.the graph in slide 4 of ppt should be updated with the data of sheet3.is tat possible///the vba code should be written in ppt. i started lyk

Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
Dim path As String

path = "C:\Mydocuments\Book1.xls"

Set newxls = xlsApp.Workbooks.Open(path)
Worksheets(sheet3).Activate



kindly help me tis is urgent...
note:i have many graphs in slide 4 of ppt.how can we update the one among them