Tables, Cells, Line Breaks and VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Marinelli - 28 Mar 2006 19:27 GMT

I have been searching for days with no reults, so any help is appreciated.

I am importing a pipe (|) delimited file into a Word document, and then
converting that text into a table, which is then appened to a table in a
template. The table in the template forces the correct column widths.

Now, in some of the cells there is text which contains a list of names.
Each name is supposed to appear on it's own line within the cell. If
I were typing this manually, I'd use SHIFT+ENTER to go to the next line.
However, since this is all being done in VBA, that is not possible.

My question: How do I mimick the action of pressing SHIFT+ENTER in the
VBA Module so that the text will fill the cell correctly? I've tried
Chr(10), Chr(13), Chr(10)+Chr(13), vbLf, vbCr, vbCrLf, but all these do
is place the text into the first cell of a new row in the table.

I've heard something about using ^l (carrot, little"L"), but if I try to
put that in within quotes, it appears as text, and VBA won't allow it
without quotes.

Help!

Thanks again

Nick

Reply to this Message

Jay Freedman - 28 Mar 2006 21:52 GMT

The constant you want is the misleadingly named vbVerticalTab, which is the
same as Chr(11).

The ^l abbreviation works only in Find/Replace operations, not in string
constructions.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> I have been searching for days with no reults, so any help is
> appreciated.
[quoted text clipped - 24 lines]
>
> Nick

Reply to this Message

Nick Marinelli - 28 Mar 2006 22:54 GMT

This isn't working. The text does not move down to the next line.

Any other ideas? Does the vbVerticalTab need to be put into the table
after it has been converted to Word?

> The constant you want is the misleadingly named vbVerticalTab, which is the
> same as Chr(11).
>
> The ^l abbreviation works only in Find/Replace operations, not in string
> constructions.

Reply to this Message

Nick Marinelli - 28 Mar 2006 23:09 GMT

Okay, I got it. I had to put some text into the imported data where I
wanted the vbVerticalTabs to go, and then after the text was converted
to a table I did a Search and Replace to insert the vbVerticalTabs where
I wanted them. Now all is well.

Thanks for your help.

Nick

> This isn't working. The text does not move down to the next line.
>
[quoted text clipped - 7 lines]
>> The ^l abbreviation works only in Find/Replace operations, not in string
>> constructions.

Reply to this Message