VBA to Transfer Data from Excel to Powerpoint – VBA Tutorial to Automate Excel Powerpoint

About this tutorial:

Video duration: 00:13:46
We can automate Excel and PowerPoint with easy VBA Code.
This example explains how to copy excel range and paste to PowerPoint Slide.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

25 thoughts on “VBA to Transfer Data from Excel to Powerpoint – VBA Tutorial to Automate Excel Powerpoint

    Ayushi Jha

    (October 7, 2020 - 5:49 am)

    How to paste as "keep source formatting" in PPT. VBA Code. Please help as it's urgent.

    Neha Patil

    (October 7, 2020 - 5:49 am)

    i want to paste as embedded what number i should give instead of 2 ?

    Akshay Chodankar

    (October 7, 2020 - 5:49 am)

    Can the data that is pasted be edited in PowerPoint? Or it can only be pasted as picture?

    Abhijit Agarwal

    (October 7, 2020 - 5:49 am)

    With above code, PowerPoint open but no slide shows up?

    matt alswanger

    (October 7, 2020 - 5:49 am)

    great video! How can I adjust the code to open the excel data into an existing powerpoint presentation?

    Etie Kamondo

    (October 7, 2020 - 5:49 am)

    Powerful but can we update excel data from PowerPoint through vba code

    Sukriti Dang

    (October 7, 2020 - 5:49 am)

    Hey! Great explanation and a very very simplistic method. Pls let me know the code for a blank slide, like you did for a slide with title (1). Thanks !

    Thạch rau câu

    (October 7, 2020 - 5:49 am)

    how to transfer data from word to powerpoint?

    raj swati

    (October 7, 2020 - 5:49 am)

    It is showing run time error 429, ActiveX component can't create Object. Help me please how to solve this error

    shivani sisodia

    (October 7, 2020 - 5:49 am)

    code is not working

    Cherry's Boom

    (October 7, 2020 - 5:49 am)

    we are pasting as a object can we edit data in ppt ?

    Yasmine Islam

    (October 7, 2020 - 5:49 am)

    Hi! Thank you, this was great. Say I have multiple slides that we would like to export to PowerPoint. How can I export multiple slides on different sheets by only clicking one button?

    Nattasira Yauvasuta

    (October 7, 2020 - 5:49 am)

    This code is early binding or late binding?

    Pranab Jain

    (October 7, 2020 - 5:49 am)

    Hi,there is no use if we cannot edit the data in PowerPoint. It is basically just a snip of excel sheet data.

    Данил Косенко

    (October 7, 2020 - 5:49 am)

    Microsoft is Sheet


    (October 7, 2020 - 5:49 am)

    Anyone can advise why it doesn't work for me. I'm very sure the file path is correct. My file path is C:JacobAPACVMODocumentdashboard.ppt. Once the powerpoint is closed and re-opened, it doesn't work and there is no error. 🙁

    Reinhard Voorspoels

    (October 7, 2020 - 5:49 am)

    Hi, great example!
    How do I copy the table in an existing slide in an existing ppt?
    F.e. I want to copy it in slide 4 of "test.pptx"
    Preferably I want to update an existing table in that slide so I can easily update the table with a click on the button.
    Would be great if you explain that also!


    (October 7, 2020 - 5:49 am)

    Great job

    David Wilson

    (October 7, 2020 - 5:49 am)


    rlvk prasad

    (October 7, 2020 - 5:49 am)

    hey its not working…saying that object required


    (October 7, 2020 - 5:49 am)

    Hi, great vid!

    How do you change the code to paste on current open slide and not to slide no. 1.


    How would you change the code to create a new slide at the end of the presentation.


    Rick Bates

    (October 7, 2020 - 5:49 am)

    You love that ass … I mean app …

    John Smith

    (October 7, 2020 - 5:49 am)

    Great video thanks for sharing. I have a question how do you copy ws.Range("A1:G2").copy from sheet1 in Excel to PPT in an existing table. I am able to paste one cell at a time but how do you paste a range. For example I am able to paste ws.range("A1").copy to tbl.cell(3,2).shape.textframe.textrange.paste but how do you copy a range from excel to a table range in PPT.

    Anish Fernandes

    (October 7, 2020 - 5:49 am)

    How to transfer from multiple excel sheets to one powerpoint presentations


    (October 7, 2020 - 5:49 am)

    Suppose that we have so many slides in different sheets then how we can copy that slides.

Leave a Reply

Your email address will not be published. Required fields are marked *