Automating PowerPoint from Excel VBA - Simple Steps to follow

  Рет қаралды 86,017

TheDataLabs

TheDataLabs

Күн бұрын

Пікірлер: 45
@ivyyu7773
@ivyyu7773 3 жыл бұрын
change to this will work --> Sheets("Excel2PowerPoint").Range("C2:K23").CopyPicture Appearance:=xlScreen, Format:=xlPicture
@vickimoore7619
@vickimoore7619 4 жыл бұрын
How do you do this for each worksheet in a workbook?
@rabearabea9279
@rabearabea9279 Жыл бұрын
Thank you so much, I was just wondering is it possible to make a slide per row of excel data?
@harmonyikennajames4100
@harmonyikennajames4100 2 жыл бұрын
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
@djamilakara28
@djamilakara28 7 ай бұрын
Very good explanation, thank you very much
@sachina4576
@sachina4576 4 жыл бұрын
Can we insert images from a location to ppt slides automatically
@MohitSharma_93
@MohitSharma_93 3 жыл бұрын
How to copy multiple charts in different slides?
@koushikc15
@koushikc15 3 жыл бұрын
how to move text from excel rows to powerpoint,not as a image but just text
@seppi6263
@seppi6263 4 жыл бұрын
you are a master! thank you so much for posting this video, helped out optimizing my work process a lot! ^^
@thedatalabs
@thedatalabs 4 жыл бұрын
Thanks for your appreciation!
@kumard6451
@kumard6451 3 жыл бұрын
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
@achrafcherakouidekkaki4060
@achrafcherakouidekkaki4060 4 жыл бұрын
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
@stargo88
@stargo88 4 жыл бұрын
Achraf Cherakoui Dekkaki have you activated the PowerPoint Library in the Settings?
@achrafcherakouidekkaki4060
@achrafcherakouidekkaki4060 4 жыл бұрын
@@stargo88 yes in the settings.
@wenfangtao2097
@wenfangtao2097 4 жыл бұрын
@@achrafcherakouidekkaki4060 Do you have any clues? Same error.
@achrafcherakouidekkaki4060
@achrafcherakouidekkaki4060 4 жыл бұрын
@@wenfangtao2097 looking if i can solve it. But nothing from my side.
@falcoloic9525
@falcoloic9525 4 жыл бұрын
appeArance not apperance
@viankaleighpatron5950
@viankaleighpatron5950 4 жыл бұрын
what if sir there is just specific word from the text box i just wan to copy paste?
@laxmanprajapati3945
@laxmanprajapati3945 Жыл бұрын
Can we copy original cells rather than copy as picture?? How can we copy original cells which can be editable in PPT after pasting?
@saisandhyajayaram5943
@saisandhyajayaram5943 4 жыл бұрын
Thanks so much! Is there a way I can print row by row from excel to Powerpoint for dynamic range of rows?
@ahmed007Jaber
@ahmed007Jaber 9 ай бұрын
Thank you so much, mate this video is instrumental in how I can automate my work now are you on linkedin????
@Moriarity09
@Moriarity09 4 жыл бұрын
How do I sepcify the .top and .left property in this ?
@kenji777jackpot
@kenji777jackpot 4 жыл бұрын
Thank you for this great video, it helped me a lot too !!
@kkaranbamne5781
@kkaranbamne5781 4 жыл бұрын
How run this Excel power point VBA programming explain clearly please
@davidquirarte523
@davidquirarte523 2 жыл бұрын
Quite nice and usefull video!
@yogeshsawant4527
@yogeshsawant4527 4 жыл бұрын
For formatting , How to identify coordinates of objects on slide while pasting data from Excel.
@shriyashdandagawhal103
@shriyashdandagawhal103 4 жыл бұрын
It shows Error 1004 Application-defined or object-defined error
@chomr772
@chomr772 3 жыл бұрын
not apperance, appearance is correct
@motamayizz
@motamayizz 3 жыл бұрын
heelp plz i need code copy value of range excel to text box in powerpoint excicted
@motamayizz
@motamayizz 3 жыл бұрын
up
@motamayizz
@motamayizz 3 жыл бұрын
up
@ShrutamJani
@ShrutamJani 3 жыл бұрын
Thank you. It's very informative 😀
@thedatalabs
@thedatalabs 3 жыл бұрын
Thanks for your feedback!
@faisalshaikh7501
@faisalshaikh7501 3 жыл бұрын
Thank you so much for this video..it is really helpful..Is der any way that we can automate "n" no of spread sheet ?
@vanessaolivieri191
@vanessaolivieri191 4 жыл бұрын
Great tutorial! Thanx!!! a little bit complex do it for many slides. Should I create a module for each one?
@AnilKashyap-cr1hq
@AnilKashyap-cr1hq 2 жыл бұрын
atlest file should be uplodaded correctly code is not working bro!!!
@nyxBRZ
@nyxBRZ 4 жыл бұрын
I'm having an error on this line of code Sheets("Excel2PowerPoint").Range("C2:K23").CopyPicture Apperance:=xlScreen, Format:=xlPicture
@samanthacruz3630
@samanthacruz3630 3 жыл бұрын
me too! did you ever figure it out?
@akbarnugraha5348
@akbarnugraha5348 3 жыл бұрын
@@samanthacruz3630 Change Apperance to Appearance
@qodrihaq
@qodrihaq 2 жыл бұрын
@@akbarnugraha5348 thanks
@matrva
@matrva 4 жыл бұрын
Superb!
@ajaykumar-hu3py
@ajaykumar-hu3py 5 жыл бұрын
not working
@thedatalabs
@thedatalabs 5 жыл бұрын
Did you add the Power Point reference in Excel? Please check.
@carlamoya
@carlamoya 2 жыл бұрын
@@thedatalabs what do you mean? The Power Pivot addin?
@bondniko
@bondniko 2 жыл бұрын
Oh, no. Take that mashed potato out, bro.
How Power Query Will Change the Way You Use Excel
9:02
Leila Gharani
Рет қаралды 1,9 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 66 МЛН
Automatic Data Transfer Excel to PowerPoint
17:12
PK: An Excel Expert
Рет қаралды 93 М.
How to make your Excel VBA code run 1000 times faster
16:55
Excel Macro Mastery
Рет қаралды 364 М.
Export Excel Charts to PowerPoint (Excel VBA Template)
9:47
Coding Is Fun
Рет қаралды 8 М.
How to Create a Timeline Chart in Excel
4:46
Excel Dictionary
Рет қаралды 52 М.
Creating Easy Data Entry Forms in Excel
9:52
Technology for Teachers and Students
Рет қаралды 3,1 МЛН