Copy range of cell values from Excel to powerpoint text box and add position.

[alfredo1971]

Hello!

I am driving crazy to find a solution to my code. I have made a code to create a presentation from Excel by copying specific charts to specific slides, but now I need to add the text of 3 cells in excel into a text box of power point giving each cell a row on the text box and be able to position the text box as well.

I want to this right after I copy each chart on each slide as the text is reference to the chart and later on the text box will be added more information manually.

Please Login or Register  to view this content.

I hope you can help me with it.

thanks

[dflak]

I can't give you the complete workbook since it contains proprietary information. However, this workbook should contain enough examples in the code to do what you want to do. The center of the code relies on the table on Sheet1. This provides a "map" of where to go on the Excel spreadsheet to copy a range or chart, and where to put it in the PowerPoint presentation. The PPObject isn't used anywhere in the code. It's for me, the human, to know what it is I'm copying.