Wise Owl Answers - How do I copy Excel data into PowerPoint using VBA?

Learn how to write VBA in Excel to copy a table into PowerPoint. You'll see how to paste as a PowerPoint table, as a picture as plain text, as RTF text, as an embedded Excel object and as a linked Excel object.

Chapters
00:00 Topic List
00:45 Referencing the PowerPoint Object Library
01:55 Creating a New Presentation and Blank Slide
03:26 Creating Slides with a Custom Layout
07:23 Copying and Pasting Excel Data into PowerPoint
09:05 Moving the Shape After Pasting
10:41 Using the PasteSpecial Method
11:59 Pasting as Plain Text
12:54 Pasting as RTF Text
13:40 Pasting as an OLE Object
14:58 Editing an OLE Object
16:20 Linking an OLE Object to the Source File

[rajeshmajumdar]

Started viewing... your videos are simply great 👍

[charanraj]

Right first time. It was quite easy to follow. Thanks

[krn]

Great video Andrew. Thanks for the in-depth answer to the question posed.

[wayneedmondson]

Hi Andrew. Thanks for your always interesting and useful videos. Much appreciated :)) Thumbs up!!

[vengion]

I was actually looking for something similar to this, you are amazing!

[leocosh]

Thank you for this video, can u please share a video or code for copying different range of data each time to different slides?

[jackyeo]

This is so helpful, thank you!

How would you adapt this to import the excel data into an existing powerpoint, rather than creating a new one?

[ahmedJaber]

thank you for this . I will use those ideas, Andrew

wonder if you use personal workbook to store macros. if so ever noticed the workbook get curropted? I have had this exerpience more than twice in less than a month

how do you organise your macros save each in a module or bunch in a module?

appreciate your feedback. thank you

[yitao_]

Great tutorial. I would like to know more about slidemaster/custom layout. Like how to paste excel value into PowerPoint using a specific theme?

[EricHartwigExcelConsulting]

Spectacular video and examples! Thank you so much for sharing!
Could you tell us what would happen if you emailed out a power point presentation with a link to an excel document?
I would assume it would fail to open the excel document but I always like to verify with an expert.

[sunny-uwmw]

This Video is very helpful thank you for uploading this video.
How to tranfer alredy inserted image in excel sheet to ppt.

[jaaaaayz]

Hi again Mr. Owl! Can I ask if there's a way to paste the excel data as picture that will cover the whole slide? Thank you in advance!!

[d.]

Hi Andrew, what happens if the user changes the name of the excel file or versions up the excel file? Does the PowerPoint link automatically update and change the file path too or does it mess up the PowerPoint? Also, what happens when the user has multiple images in Powerpoint from the same excel file but only wants to update just one image?

[surajmthomas]

Is it possible to paste in PowerPoint using Source Formatting. I need an editable table to be pasted in Source Formatting. When I use the Paste option I’m getting the vba to paste only as a text table without any formatting

[VillaOuk]

Great video. Thanks. Could you share how to send file attachment to Telegram bot by VBA. Thank you, Andrew

[asadmahboob]

Great video indeed. I became a VBA developer following your videos.
My Question: How can we copy the text formatting along with text in Excel and paste the same text with formatting to PPT TextBox?
Like we do in excel, copy the text and paste it as

[PJay-nseh]

I love your videos
But I'm having trouble installing SSIS. I'm always told to close some Microsoft services but I can't locate them too

[pm_ght]

Hello sir,

Just a question.

Is it possible to paste an excel data to powerpoint using vba, without creating a powerpoint slide on vba? In example, a macro enabled worksheet (data source) transferring to a powerpoint slide (receiver) . Which is like the copy from worksheet to worksheet, but this time, worksheet to powerpoint slide?

Thanks

[yogeshindulkar]

How to add excel charts into power point and different headers for eg. Job role breakdown: 36% of leads were Manager. How to change the % in each header and respective name using vba

[sudheerkupchand]

Is it possible to copy Excel data into OneNote using VBA? Like a copy and paste and not printing as a picture to OneNote? If possible, can you please do a video showing this? Thanks!