Pasting a string into a table

J

John

Hi there,

I'm trying to paste a string of into a PowerPoint table. I've generated the
string from Visio from a collection (see below) but I'm not sure how to get
it to separate each entry to a subsequent row in the table (ie When I right
click and paste in the top cell of a PowerPoint table, I want it to paste
each new name in the string to each cell (vertically))

Should I be using something other than vbCr?

Thanks in advance

John


For Each x In colShps
strNewNames = strNewNames & x & vbCr
Next x

MyData.SetText (strNewNames)
MyData.PutInClipboard
 

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

Top