MAcro to paste excel table into PPT slide automatically

Hello GUys,

Need help on macro. I am attaching sample file.
I want the data and table in the excel sheet to be pasted in PPT slide automatically.

Thanks for the link.

But I am very New to Macro. so can you please write the code in my attached sheet and send me the updated sheet that will be very helpfull for me thanks a lot

Regards
Sam

Hi sameru,

See this file. Hope it could help you.

i divided it to 3 slides because having them in one slide is kinda crowded.

Enable content first, then click the buttons one by one.
They will all go to one power point slides. :D

Thanks A lot its really help full.
How can i view the code and if it is poosible to make it in one cilck. As I want the whole table in one slide

Regards
Sam

Hi Sameeru,

You can click ALT + F11 to view the codes

If you wish to change the columns to be exported in PPt, you can just simply change the range. You can see it in the codes! :D

Anyway, if you want to view it in one slide,
it will be very small and not advisable. But you can try just change the range.

Sorry Im not able to see the code its coming blank and asking some password after pressing ATL + F11

Hi MikeTron and Sameeru,

this file is unprotected.

or you can use this code.

CreatePPT - Button 1
CreatePPT2 -Button 2
CreatePPT3- Button 3

Please Login or Register  to view this content.

Hi MikeTron,

did you click "Microsoft powerpoint 12.0 Object Library" on the references? References - VBAProject.jpg