Guys,

I am writing a macro in powerpoint to link a excel sheet using AddOLEObject..My code is..
ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=120#, Top:=110#, Width:=480#, Height:=320#, FileName:="C:testexcel.xls", Link:=msoTrue).Select

This works fine for me..

But I have multiple worksheet in the "testexcel.xls" file and I want to link all the worksheets into powerpoint slides one by one.
Any idea of how to do this ?
Note: Even if it can be accomplished without writing a macro also appreciated(design time).

Thanks for your help..
Kandan.