How do i keep Leading zeros in .CSV file saved as from .xls file

[Vikas]

I am using VBA for saving one worksheet as .csv file format from a Excel
workbook .One of the columns in that contains values as 00033 and so on.When
my save as statement in vba code executes then i lost the leading zeroes from
that column and finally get only 33 . Is there any way by which i can keep
leading zeroes in that perticuler column.

[Niek Otten]

Rename the file a .TXT file and then import. Excel will give you options to choose between Date, text, number, etc.

--
Kind regards,

Niek Otten

"Vikas" <Vikas@discussions.microsoft.com> wrote in message news:34637E0D-4834-4774-9BFC-513388F04B0F@microsoft.com...
>I am using VBA for saving one worksheet as .csv file format from a Excel
> workbook .One of the columns in that contains values as 00033 and so on.When
> my save as statement in vba code executes then i lost the leading zeroes from
> that column and finally get only 33 . Is there any way by which i can keep
> leading zeroes in that perticuler column.