G

#### Ginge1968

not sure if anyone can help on this.

I have a worksheet that contains a header row.

When saving the data in this worksheet as a tab delimited file, excel would

normally add the delimiters to equal the longest record (row of data).

E.g.

Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8

a b c d e f

a b c d e f

a b c d e f

a b c d e f

a b c d e f

Saving as a Tab Delimited or Comma Delimited file would result in the

following .txt file (I have used comma delimited format as this is easier to

demostrate the problem!)

Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

This works whether there is a header row or not. If row 3 is the longest

record, then the delimiters will be added to equal the longest row for the

rows before and after the longest record.

However, the problem I have encountered is this only works for the first 15

rows.

From row 16, no delimiters are added after the last cell with any data in

for that row.

Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f,,

a,b,c,d,e,f

a,b,c,d,e,f

a,b,c,d,e,f

a,b,c,d,e,f

This does not happen when saving the file as part of a VB macro.

Can anyone explain why this is happening and whether anything can be done

about it. I need the delimiters for all rows in the file as it is being

loaded into an application that requires a fixed length record.

Thanks