Pasting Text from Excel cell to Powerpoint Title Box

S

sukhin

I have some text in an Excel Worksheet that I need to transfer to a
slide title in powerpoint.

I am currently using the following code:

' Add Title Text to Slide
ppNewSlide.Shapes.Placeholders(1).TextFrame.TextRange.Text = sTitle

sTitle is a variable that is populated from a cell in Excel ( sTitle =
NameRange.Value).

The problem I am having is that line breaks that I enter in the Excel
cell using Alt+enter do not carry over to the Powerpoint slide title.

Any help would be greatly appreciated.

Thanks,

Sukhin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I paste a chart from Excel into a powerpoint slide "Placeholde 1
VBA - (re-) Set a Table Style 2
Paste to excel from word - auto format problem 1
How to disable synchronization of text boxes. 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Import text into existing slides 0
How do I create slide titles in powerpoint from excel? 2
Import text into existing photo slides 2

Top