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

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

Using vba to write to Powerpoint presentation requires that you add a reference to the Powerpoint object library - see pic below

ReferencesToPowerpoint.jpg

The way I would approach your problem

1 List all existing textboxes that exist in the PP presentation (see code below)
2 Rename the textboxes into something more meaningful (to make life easier in future!)
3 Write a 2 column table in Excel with the (new)textbox names and cell Ref (= where the text to be copied is)
4 Write vba procedure to transfer those values automatically

If that sounds ok to you:
1 open your PP presentation (which contains textboxes with latest text)
2 open the attached file
3 run the macro with {CTRL} + t

Hopefully that will give you a list of your textboxes slide by slide

If that works then we can quickly do steps 2,3 and 4
Let me know what you think

Please Login or Register  to view this content.

An afterthought to post#3
I am a creature of habit and favour writing my code in the Excel file. It could just as easily sit (with a few mods) in the PowerPoint file