Automating PowerPoint from Excel VBA - Simple Steps to follow
HTML-код
- Опубликовано: 14 окт 2024
- Excel To PowerPoint Automation
In this video, we will learn how to automate PowerPoint Slides with from Excel using VBA code. We will copy the graphs available in Excel and Move it to PowerPoint automatically.
#VBATips #TheDataLabs
Please follow the below link to download the Excel file used in this video.
drive.google.c...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!
change to this will work -->
Sheets("Excel2PowerPoint").Range("C2:K23").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Thank you so much, I was just wondering is it possible to make a slide per row of excel data?
Very good explanation, thank you very much
you are a master! thank you so much for posting this video, helped out optimizing my work process a lot!
^^
Thanks for your appreciation!
Thank you so much, mate
this video is instrumental in how I can automate my work now
are you on linkedin????
How do you do this for each worksheet in a workbook?
Thank you for this great video, it helped me a lot too !!
Hello I have a list of different power point files that are to be presented according to a schedule described in an excel spreadsheet. Please I need a breakdown I'm totally confused
Great tutorial! Thanx!!! a little bit complex do it for many slides. Should I create a module for each one?
Thanks so much! Is there a way I can print row by row from excel to Powerpoint for dynamic range of rows?
Thank you so much for this video..it is really helpful..Is der any way that we can automate "n" no of spread sheet ?
Can we copy original cells rather than copy as picture?? How can we copy original cells which can be editable in PPT after pasting?
Can we insert images from a location to ppt slides automatically
Quite nice and usefull video!
what is the vbs to right click edit a linked excel object in a pptx slide.? doing it manually causes mis posisionig & allignment problem in the excel object
How to copy multiple charts in different slides?
how to move text from excel rows to powerpoint,not as a image but just text
Thank you. It's very informative 😀
Thanks for your feedback!
not working,
visual basic send a error execution 1004 and this ligne is collored with yellow
Sheets("Excel2PowerPoint").Range("C2:K23").CopyPicture Apperance:=xlScreen, Format:=xlPicture
Achraf Cherakoui Dekkaki have you activated the PowerPoint Library in the Settings?
@@stargo88 yes in the settings.
@@achrafcherakouidekkaki4060 Do you have any clues? Same error.
@@wenfangtao2097 looking if i can solve it.
But nothing from my side.
appeArance not apperance
what if sir there is just specific word from the text box i just wan to copy paste?
For formatting , How to identify coordinates of objects on slide while pasting data from Excel.
How run this Excel power point VBA programming explain clearly please
How do I sepcify the .top and .left property in this ?
heelp plz i need code copy value of range excel to text box in powerpoint excicted
up
up
Superb!
It shows Error 1004
Application-defined or object-defined error
not apperance, appearance is correct
I'm having an error on this line of code
Sheets("Excel2PowerPoint").Range("C2:K23").CopyPicture Apperance:=xlScreen, Format:=xlPicture
me too! did you ever figure it out?
@@samanthacruz3630 Change Apperance to Appearance
@@akbarnugraha5348 thanks
atlest file should be uplodaded correctly code is not working bro!!!
Oh, no. Take that mashed potato out, bro.
not working
Did you add the Power Point reference in Excel? Please check.
@@thedatalabs what do you mean? The Power Pivot addin?