Macro to update excel data table in power point

Hi,

I have 4 worksheets in workbook which contains different data table.

e.g.
Sheet1 Product Name ("A2:A20") vs Product Y ("B2:B20") & chart
Sheet2 Month("A2:A20") vs Sales quantity ("B2:B20") & Chart
Sheet3 Data table
Sheet4 Data table (2)

Excel data table will be updated by user using macro and I want to make it auto updated in presentation slide (PowerPoint) as well.

I have tried in PowerPoint with Insert > Object > Create file from > Link but not helpful as it only applicable for one worksheet. Only the last worksheet saved in excel will be linked to presentation slide.


Is there anyone can help to create VBA code to solve it?

Hi,

Can anyone help me?

Attached herewith the sample of workbook,

Instead of updating the exisiting pptm. can anyone help to crete presentation directly from excel by using CreateObject("Powerpoint.Application")

have a look to the attached file and copy the attached file on your drive and try it

Please Login or Register  to view this content.

Hi Naveed,

Thanks for help me.

There is an error on myShapeRange.Select

Please Login or Register  to view this content.

and one more thing, if possible chart to be Embeded instead of created as picture. in order to allow user edit in case of wrong data found during presentation.

regarding error i already test 3 to 4 times for me nothing is showing as error

regarding next query i will update that give me some time

--> if the suggestion and answer u feel nice and good please click on * Icon and leave ur comments to that post.

Hi Naveed,

I think it could be due to setting,

Insted of addding Microsoft PowerPoint 15.0 Object Library in Tools > References, Is there any setup for ppt object need to be added?

Befoere I add-in Microsoft PowerPoint 15.0 Object Library it does not run, Then after adding it runs but stop at myShapeRange.Select

Really appreaciate your assistance, I will also try to run it at another Desktop to see the result.

I think that will not work in MS-Office Version 2013 , i mostly worked on 2007 & 2010 only.

if u need still any assitance regarding that plz ask expert, moderators i am sure they will help you perfectly

Please dont forget give reputation points(click on * and leave your comments at particular post).