I have a extern automation system where I create CSV -file to be later
imported into Excel 2003. There is 150 ascii text string variables with
different lengths (but always same) in row and 70 rows. I can add commas ok
by adding ',' between variables.
This way I can import variables in separate colums. Now I would like to
bequin new rows automaticly when importing. What is the right delimiter
instead of ',' to be inserted in the end of the row?

Thanks in advance

Try "vbcrlf" or Chr(13)


HTH,
HP

On Dec 17, 2:15 pm, Janne <Ja...@discussions.microsoft.com> wrote:
> I have a extern automation system where I create CSV -file to be later
> imported into Excel 2003. There is 150 ascii text string variables with
> different lengths (but always same) in row and 70 rows. I can add commas ok
> by adding ',' between variables.
> This way I can import variables in separate colums. Now I would like to
> bequin new rows automaticly when importing. What is the right delimiter
> instead of ',' to be inserted in the end of the row?
>
> Thanks in advance

Concatenate the predefined VBA constant vbNewLine at the end of each line.

Rick


"Janne" <(E-Mail Removed)> wrote in message
news:19D5A601-E9C7-4CB7-BCB3-(E-Mail Removed)...
>I have a extern automation system where I create CSV -file to be later
> imported into Excel 2003. There is 150 ascii text string variables with
> different lengths (but always same) in row and 70 rows. I can add commas
> ok
> by adding ',' between variables.
> This way I can import variables in separate colums. Now I would like to
> bequin new rows automaticly when importing. What is the right delimiter
> instead of ',' to be inserted in the end of the row?
>
> Thanks in advance