Thank you so much for this video! I've never wrote any code in VBA and I am currently trying to automate the process of copying text from pictures/screenshots into word/excel and from there into a recipe layout in powerpoint. I was able to automate the process from Excel to PPT with your video, thank you! :)
I appreciate your hard work, but this doesn't work in Office 365. The code opens up powerpoint but that's all. Maybe you were running code from a different module and that got overlooked in your video editing. By the way you had a typo in the 4th to last line: "powerpointASS.Visible = True". I'm sure that the code will work with a small tweak.
Hi, great vid! How do you change the code to paste on current open slide and not to slide no. 1. Also, How would you change the code to create a new slide at the end of the presentation. Thanks
How do you print the ppt after you copy and paste? Could you please add that part? also what if you have to do that for more than one sheet in excel workbook. Thanks in advance.
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 !
Hello. Do you know how to Paste a Range Table as Keep Source Formating from excel to PPT? I'd like to know much about that.. And hope you wanna share the way. Thanks :)
I want to apply the entire data of on Excel to PowerPoint, that can be of different size. It varies and we need a code that it should fit to the slide. Can you help
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?
Excel Destination thanks for the response; I followed all steps mentioned in your video. If there is some additional step to link powertpoint to excel then please let me know or let me which video i can see to understand it. Thanks
Such a good and informative video😄 . Can u please help me with this questions .How to add multiple charts in different slides ? How to ensure fit chart sizes ? Please help me. P.s thank u for the video 😀
Anyone can advise why it doesn't work for me. I'm very sure the file path is correct. My file path is C:\Jacob\APACVMO\Document\dashboard.ppt. Once the powerpoint is closed and re-opened, it doesn't work and there is no error. :(
Chandrashekhar Ji...thanks for watching...There are multiple ways, you can use the VBA code, I have provided in this tutorial...let me explain little bit more...Dim r As Range Set r = ThisWorkbook.Worksheets("Sheet1").Range("A3:G11") ***we are giving range to variable named r...we can use this variable more than one time by assigning different ranges Set myslide = mypresentation.slides.Add(1, 11) ***here 1 denotes 1st slide r.Copy myslide.Shapes.PasteSpecial DataType:=2 Set myshape = myslide.Shapes(myslide.Shapes.Count) please see the message after 3 stars...I have limited time...other wise, I would have done this for you...in more than one methods...thanks again
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.
Good question. I have been struggling with this myself. I can paste an excel data range as a table into powerpoint, and I can paste data from an excel range into a powerpoint table, but only one cell at a time. I can't seem to paste into a table in a single step.
Thank you so much for this video! I've never wrote any code in VBA and I am currently trying to automate the process of copying text from pictures/screenshots into word/excel and from there into a recipe layout in powerpoint. I was able to automate the process from Excel to PPT with your video, thank you! :)
Thanks a lot. It is very clear and easy to practise
Simple and perfect coding for someone with their first automation on powerpoint
Very nice explained..
Thank you so much 🙂
9:49
For pasting as device independent bitmap what number is applicable in datatype?
I appreciate your hard work, but this doesn't work in Office 365. The code opens up powerpoint but that's all. Maybe you were running code from a different module and that got overlooked in your video editing. By the way you had a typo in the 4th to last line: "powerpointASS.Visible = True". I'm sure that the code will work with a small tweak.
You are awesome. This will give me answer of "From where to start?"
thanks
Hi, great vid!
How do you change the code to paste on current open slide and not to slide no. 1.
Also,
How would you change the code to create a new slide at the end of the presentation.
Thanks
great video! How can I adjust the code to open the excel data into an existing powerpoint presentation?
I need this too
Hello...Its a great video.Thank you.
Can we do this for multiple sheets from excel ?
Great job
Thanks a lot for this, but can you video to copy over grouped and ungrouped table as well in these slides.
ok
@@ExcelDestination thanks so much!
hi, I have been trying to follow your steps twice. but when I click the command button at the end, nothing is coming out. help.
i want to paste as embedded what number i should give instead of 2 ?
how do you add footers to the PP slides?
How do you print the ppt after you copy and paste? Could you please add that part? also what if you have to do that for more than one sheet in excel workbook. Thanks in advance.
Hi. How do I change the VBA code so that I open a new powerpoint presentation with slide size A3 portrait? Thanks
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 !
for any vba task, you can write to exceldestination@gmail.com
To do a blank slide you should use 12 instead of 11.
any chance we can connect?
Can the data that is pasted be edited in PowerPoint? Or it can only be pasted as picture?
There would be different code to paste anything in different manners.
Mine says subscript out of range. What does that mean
hi, thanks for this video, but i need a help regarding copy more than one range of data to different slides, like pagewise from excel to PowerPoint.
Thanks for sharing video. For me some error occurred blank screen. Can you share code. Please its urgent for my work.
Please admin can you share code?
Hi sir how we can send excel data to another software rather than ppt
Hello powerpoint is loading up but its loading with a grey screen. Have I done something wrong ? Thanks again
How to enlarge the image in powerpoint
we are pasting as a object can we edit data in ppt ?
yes, you can. It would require additional vba code.
This code is early binding or late binding?
LATE BINDING
Hi there! Thanks for the video! This is amazing!, But after creating this Powerpoint, how do I add data to a new slide in this Powerpoint?
Hello. Do you know how to Paste a Range Table as Keep Source Formating from excel to PPT? I'd like to know much about that.. And hope you wanna share the way. Thanks :)
sure......let me try to create tutorial for that.
@@ExcelDestination Thanks bruh.. Can't wait the tutorial soon! 😄
I want to apply the entire data of on Excel to PowerPoint, that can be of different size. It varies and we need a code that it should fit to the slide. Can you help
let me try to create a tutorial for that.
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?
You can make use of Looping statement to do this. For any VBA Support, you can write to exceldestination@gmail.com
can you help me its not working for me nothing is happening when i press the button
hey its not working...saying that object required
Powerful but can we update excel data from PowerPoint through vba code
good question...........let me check
With above code, PowerPoint open but no slide shows up?
have you connected power point with excel through reference in vba editor ? may be that can help.
Excel Destination thanks for the response; I followed all steps mentioned in your video. If there is some additional step to link powertpoint to excel then please let me know or let me which video i can see to understand it. Thanks
Such a good and informative video😄 . Can u please help me with this questions .How to add multiple charts in different slides ? How to ensure fit chart sizes ? Please help me.
P.s thank u for the video 😀
How to transfer from multiple excel sheets to one powerpoint presentations
Is this file downloadable
I want to excel text in power point title
It is showing run time error 429, ActiveX component can't create Object. Help me please how to solve this error
how to transfer data from word to powerpoint?
Anyone can advise why it doesn't work for me. I'm very sure the file path is correct. My file path is C:\Jacob\APACVMO\Document\dashboard.ppt. Once the powerpoint is closed and re-opened, it doesn't work and there is no error. :(
Suppose that we have so many slides in different sheets then how we can copy that slides.
Chandrashekhar Ji...thanks for watching...There are multiple ways, you can use the VBA code, I have provided in this tutorial...let me explain little bit more...Dim r As Range
Set r = ThisWorkbook.Worksheets("Sheet1").Range("A3:G11")
***we are giving range to variable named r...we can use this variable more than one time by assigning different ranges
Set myslide = mypresentation.slides.Add(1, 11)
***here 1 denotes 1st slide
r.Copy
myslide.Shapes.PasteSpecial DataType:=2
Set myshape = myslide.Shapes(myslide.Shapes.Count)
please see the message after 3 stars...I have limited time...other wise, I would have done this for you...in more than one methods...thanks again
provide also VBA code file
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.
Good question. I have been struggling with this myself. I can paste an excel data range as a table into powerpoint, and I can paste data from an excel range into a powerpoint table, but only one cell at a time. I can't seem to paste into a table in a single step.
How to paste as "keep source formatting" in PPT. VBA Code. Please help as it's urgent.
powerpointass
how did it work ?
Hey, this is a family show.
code is not working
Same
Code is not working