none
VBA to copy Excel data range and paste in PowerPoint text boxes RRS feed

  • Question

  • Hello,

    I do not have much knowledge in VBA programming but would like to automate a repetitive task that I am doing every week. 

    I need to copy a range of cells (horizontal/vertical range) with its font color from Excel and then paste them into PowerPoint Text boxes.

    I am currently manually copying each Excel cell and then pasting as values in each PPT textbox which is very time consuming and exhaustive, making my work prone to errors.

    If any of you VBA experts know of a simple code to achieve this, I kindly request you to share it with me.

    Thanks in advance for your amazing help
    Monday, November 28, 2016 7:13 AM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,
    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, November 29, 2016 5:49 AM
  • Hi,

    Please visit Copy & Paste An Excel Range Into PowerPoint With VBA  It demonstrates how to copy excel range into PowerPoint. You could adjust to your files.

    To add textbox, we could use Shapes.AddTextbox Method (PowerPoint).

    To refer the textbox and change its content, we could use Shape.TextFrame Property (PowerPoint)

    If you have any issues, please feel free to let me know.

    Regards,

    Celeste

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.  


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 1, 2016 9:28 AM
    Moderator