Question Locked

Need help to embed a whole excel worksheet in Powerpoint

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi friends. I need to embed/insert a whole excel sheet into a powerpoint presentation as an object.

I have to use VBA to pull details from excel sheet and populate a PPT template. There is another workbook which is supposed to be inserted as an object, e.g. excel icon will be there in the powerpoint and on clicking it the the worksheet will open.

Here is what I have been using:

oPS=oPP.Slides(1)
oPS.Shapes.AddOLEObject _
Classname:="Excel.sheet",FileName:="abc.xls",DisplayAsIcon:=msoTrue

where oPS is
Dim oPS As Powerpoint.slide

The error is am getting is:
shapes(unknown member): invalid request

I am a total newbie to VBA and this is a on off assignment. Any help will be greatly appreciated.

2 replies

by tobif

Hi,
I don't know the answer to your question. But in order to help someone else answer, please mention which version of office you're using.

This discussion is closed to new replies.