How to Create A PowerPoint Presentation from Excel using VBA v1

Some times you may want to add Charts to PowerPoint Slides directly from Excel. In this video I have explain how to create a PowerPoint Presentation from Excel using VBA

Пікірлер: 65

  • @javierreyes7164
    @javierreyes71646 ай бұрын

    Awesome presentation Vijay!! Thank you

  • @allabout1135
    @allabout11355 жыл бұрын

    Now need code to transtorm this presentation to email and sent it out :) Well done my friend. You have good potentional. Thanks for sharing.

  • @vijay_

    @vijay_

    5 жыл бұрын

    kzread.info/dash/bejne/aH5rvNyBfZTHp7w.html, this video helps you to attach file and send mail

  • @sreenivasdesu
    @sreenivasdesu4 жыл бұрын

    Vijay Thanks a lot for your service to humanity by sharing your knowledge

  • @vijay_

    @vijay_

    4 жыл бұрын

    It's my pleasure

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @gelenkova
    @gelenkova4 жыл бұрын

    Hi Great tutorial, In your excel you have charts, however If I have Image/pic in Excel how do I copy this picture/image to an existing Powerpoint on specific slide and size? Thank you

  • @vijay_

    @vijay_

    4 жыл бұрын

    If you want to select the picture The code will be Acrivesheet.shapes("pictureshpae name"). Copy And rest of the code same as described in the video

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @dshani6425
    @dshani64254 жыл бұрын

    Thanks for your youtube clip. For me, I had company's PPT slide (slider footer was designated). My purpose is exporting 1) some range of excel to the slide in the template slide and also 2) an excel cell data for "page title of slide". Once export to power point, I have no idea how to do VBA to set font size and font color for that page title. Could you help me, Vijay?

  • @vijay_

    @vijay_

    4 жыл бұрын

    Will try to Create a Code..

  • @ivy190
    @ivy1904 жыл бұрын

    I have a scenario in which I need program to convert rows in excel table to slides. Excel table contains multiple columns. Each row contains data that are to make up the contents of a slide. I'd like to run my program and "update" the slides. If there's a new row added to the table, a new slide is created. If a row is deleted, a slide is deleted. If data in a row changes, data in the slide changes accordingly. I am struggling with how to phrase the if conditions. Can I email you for more help? Thanks!!

  • @vijay_

    @vijay_

    4 жыл бұрын

    Yes you can details to my email

  • @MikeyMikeCPW
    @MikeyMikeCPW Жыл бұрын

    Very informative video thank you. Do you have a link to the VBA Source code please?

  • @vijay_

    @vijay_

    Жыл бұрын

    I hv explained step by step and you can pause the video to see the code.

  • @shivkantsinghal
    @shivkantsinghal4 жыл бұрын

    Hi Vijay, thanks for the informative video. I have a question. Is it possible to convert an excel file into a predefined ppt template? Thanks

  • @vijay_

    @vijay_

    4 жыл бұрын

    Not possible, because there are two different applications. But you can use the same excel file for repeated ppts with bit better code

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @danikaezrasalvahan6627
    @danikaezrasalvahan66274 жыл бұрын

    Hi Vijay! Thank you for this very informative video clip :) May I ask if there is a way to automate charts in PowerPoint in such a way that data can be edited in ppt itself? Because most macros paste the charts in ppt as image or picture, hence, I cannot edit the data. To add, what if I have an existing PowerPoint template (with company logos, footer, font color, etc.), how can I create charts using my template? I was thinking, is it possible to have the macros in the PowerPoint instead of creating it in Excel? But of course, the data would still be from Excel. Hope you could help me with this. Thank you very much :)

  • @vijay_

    @vijay_

    4 жыл бұрын

    Good Question , Let me create another Video and Post for you

  • @danikaezrasalvahan6627

    @danikaezrasalvahan6627

    4 жыл бұрын

    Thank you so much Vijay :) Looking forward to watch the video. :)

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @mylesmarlon1526

    @mylesmarlon1526

    2 жыл бұрын

    i know it is kinda off topic but do anyone know a good place to stream new movies online ?

  • @zahiredward3884

    @zahiredward3884

    2 жыл бұрын

    @Myles Marlon meh I use Flixportal. just google after it:P -zahir

  • @mudrikaagrawal7441
    @mudrikaagrawal74414 жыл бұрын

    Hi sir, very descriptive video and easy to understand... But sir is it possible to paste these charts in our predefined template of office??

  • @vijay_

    @vijay_

    4 жыл бұрын

    Yes Mudrka , it is possible.

  • @mudrikaagrawal7441

    @mudrikaagrawal7441

    4 жыл бұрын

    @@vijay_ sir could you please help us in writing code of it.. or please post video accordingly so that we could learn

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @janema5355
    @janema535511 ай бұрын

    For title slide - Let's say I wanted the text from a specific cell in excel eg. Cell A1.

  • @mlatiffinnovate9943
    @mlatiffinnovate9943 Жыл бұрын

    Brilliant But how do I add subtitle text please help

  • @Moriarity09
    @Moriarity094 жыл бұрын

    Hi Vijay, how can i set the powerpoint size to custom 4:3 ? Please help / advise.

  • @vijay_

    @vijay_

    4 жыл бұрын

    ActivePresentation.PageSetup.SlideSize = ppSlideSize35MM use this code

  • @vijay_

    @vijay_

    4 жыл бұрын

    Also try watching my recently video on creating complete powerpoint using excel vba

  • @maskoormewati3550
    @maskoormewati35504 жыл бұрын

    I have an Excel file and a standard Power Point file that is already saved at a location. I want to copy the data from excel to the saved ppt. and then save it at a location. Basically how can I copy and paste the data in an already saved file? Because I already have the slides in place so need not to add those, just paste on the already created slides. Please suggest

  • @vijay_

    @vijay_

    4 жыл бұрын

    Will create a video and share within couple of days

  • @vijay_

    @vijay_

    4 жыл бұрын

    To day posting a video on creating a complete power point presentation with few clicks from Excel. It will be live by 6 pm. Please watch it.

  • @SaadKhan-lg8zy
    @SaadKhan-lg8zy4 жыл бұрын

    I just wanna know 2 things whivh are as following: 1) How to insert a backgorund image in certain slide or a logo and its alignment on that partucular slide 2)How to insert more than one graph in a slide and also their alighment.

  • @vijay_

    @vijay_

    4 жыл бұрын

    Please watch these Videos (Part1 to Part 3) to get answer for your questons!

  • @pravinsatbhai2412
    @pravinsatbhai24124 жыл бұрын

    Hello sir, I want make the userform in powerpoint and want its database to be stored in excel. Can you please guide for this..

  • @vijay_

    @vijay_

    4 жыл бұрын

    What will you do with User-form, What is the Objective (final result)

  • @pravinsatbhai2412

    @pravinsatbhai2412

    4 жыл бұрын

    @@vijay_ Basically this will be the userfor for the new join employees. Employee will fill their Names,Address, DOB and all other things in the form.

  • @syedabrash7492
    @syedabrash7492 Жыл бұрын

    I want to add range of cells in ppt. How to do it?

  • @vijay_

    @vijay_

    Жыл бұрын

    Will share the code

  • @koushikc15
    @koushikc153 жыл бұрын

    how do u copy text from multiple rows in excel to powerpoint not as picture but as text

  • @vijay_

    @vijay_

    3 жыл бұрын

    Any thing which goes into PowerPoint will be considered as shape. But there is a type of shape to be defined. Will share a code in some time

  • @vishwaskeswani8310

    @vishwaskeswani8310

    2 жыл бұрын

    @@vijay_ Do you made that video of copy text to powerpoint using VBA?

  • @christinahepzy
    @christinahepzy3 жыл бұрын

    Please make a tutorial using Spin Toolbar.

  • @vijay_

    @vijay_

    3 жыл бұрын

    Sure

  • @christinahepzy

    @christinahepzy

    3 жыл бұрын

    @@vijay_ Spin toolbar in the presentation slide which changes value of excel and that reflects the same in the chart in the presentation slide automatically. This is an urgent requirement. I could not find any video explains this. Please upload a video tutorial at the earliest, that would be the greatest help! 🙏🏼 thanks in advance sir! 🙌🏻

  • @vijay_

    @vijay_

    3 жыл бұрын

    @@christinahepzy Will try, currently I am in bed rest due to some health issues. Will try to do video at the earliest

  • @christinahepzy

    @christinahepzy

    3 жыл бұрын

    @@vijay_ so sad. Take care of your health 🙌🏻 I hope you feel better soon :)

  • @atulpardhi9638
    @atulpardhi963810 ай бұрын

    I have added chart in excel. Now i want to arrange that picture. Please give me coding

  • @atulpardhi9638

    @atulpardhi9638

    10 ай бұрын

    In ppt

  • @Aditya_9696
    @Aditya_96963 жыл бұрын

    How to go back to previous slide using vba code?

  • @vijay_

    @vijay_

    3 жыл бұрын

    you need to give slide number in the code

  • @Aditya_9696

    @Aditya_9696

    3 жыл бұрын

    @@vijay_ okay

Келесі