Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Need help to embed a whole excel worksheet in Powerpoint
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.