T
Teddy
Hi
There is aparently a bug in excel
When I save my workbook with the code
SaveAs Filename:=filename, FileFormat:=xlCSV
I get too many separators!
The first rows is with wrong number of fields
The parameter local is not involved - tried to set it but no result.
There are emty cells from C1 (col 3) to IV1 (col 255)
There are emty cells from H1 (col 8) to IV2 (col 255)
and so on
But not on all rows as you see..
Is there a way out of this?
*BOF*
field1;field2;;;;;
field1;field2;field3;field4;field5;field6;field7
field1;field2;field3;field4;field5;field6;field7
field1;field2;field3;field4;field5;field6;
field1;field2;;;;;
field1;;;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;;
*EOF*
Best regards Ted
There is aparently a bug in excel
When I save my workbook with the code
SaveAs Filename:=filename, FileFormat:=xlCSV
I get too many separators!
The first rows is with wrong number of fields
The parameter local is not involved - tried to set it but no result.
There are emty cells from C1 (col 3) to IV1 (col 255)
There are emty cells from H1 (col 8) to IV2 (col 255)
and so on
But not on all rows as you see..
Is there a way out of this?
*BOF*
field1;field2;;;;;
field1;field2;field3;field4;field5;field6;field7
field1;field2;field3;field4;field5;field6;field7
field1;field2;field3;field4;field5;field6;
field1;field2;;;;;
field1;;;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3;;;;
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;field2;field3
field1;;
*EOF*
Best regards Ted