How to embed an excel file in powerpoint using VBA

  • I need to embed excel file as object in powerpoint using vba macros on active slide..




    Can anyone help me.



    I tried below code,but it was creating new ppt and adding file on given location.


    But I need to browse and select the excel file in active slide




  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags

    Note: no apostrophe in the tags, just used for demonstration here.

    ['code]


    your code goes between these tags


    ['/code]


    Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.


    Thanks.

  • This works for me. It might help you adapt your code



  • Not worked, I need to write macro for browse and select the excel file and create as object in existing slide itself.


    For example:


    If i run the macro,

    1) Need to browse and manually choose the location and select the file,

    2) it must create as excel object in my current slide