fb1990
asked on
VBA to Copy Text from Excel to PowerPoint
Hello EE,
Can someone please help demonstrate how to copy Text from Excel to a PowerPoint shape. I have a vba that creates PowerPoint slides and copy charts to PowerPoint. I also have Text in excel that i want to copy and be placed on the slide and inside a shape on the slide
Please help
Can someone please help demonstrate how to copy Text from Excel to a PowerPoint shape. I have a vba that creates PowerPoint slides and copy charts to PowerPoint. I also have Text in excel that i want to copy and be placed on the slide and inside a shape on the slide
Please help
ASKER
Hi Jamie,
Here is a code from my vba to specify the text, but i want to reference cell C10 in Sheet3 of my excel and paste to the focus slide
Thnaks for your help
Here is a code from my vba to specify the text, but i want to reference cell C10 in Sheet3 of my excel and paste to the focus slide
With PPSlide.Shapes.AddShape(Type:=msoShapeRectangle, _
Left:=550, Top:=175, Width:=350, Height:=240).TextFrame _
.TextRange.Text = "Some Text in cell C120 of Sheet3"
End With
Is it possible specify the cell # and Sheet where the comments should come from?Thnaks for your help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Jamie for your assistance
Open in new window
You'll need to add cases for objects not existing etc. and error handling and object clean up.