How include both data and charts from Excel to PPT Slide by Slide. RRS feed

  • Question

  • Hi All, 

    I want to extract a set of data and chart and again a set of data and may be again chart from a Excel sheet to PPT using VBA. 

    Slide.Shapes.PasteSpecial (DataType, ....) we can use only one data type to extract at a time. i have Data and Charts spread across Sheet which can potentially create a PPT. But how to differentiate Data and charts and extract to PPT slides one by one. Please help.

    Friday, March 16, 2018 1:37 PM

All replies

  • Hello,

    This is not the correct forum. Since you are using VBA I'm moving this question to the VBA forum.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Friday, March 16, 2018 2:21 PM