I have a specific problem.
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:
where oPS is
The error is am getting is:
shapes(unknown member): invalid request
There was some info on net but they were using ActivePresentation and I am creating macro in excel not in powerpoint.
Sorry If a lot of what I say is not making much sense. I am a total newbie to VBA and this is a one off assignment. Any help will be greatly appreciated.