Hi There,

I am writing a macro on how to open a text file in excel
in such as way that my file maintain a "number" text as a
text. Please see below for an example:

I want to open this in column as a text NOT a number.

Code IDNO Region
0001 12345 N1234
0002 35353 C3535
..
..
so on.

How do I do that?

Thanks in advance for your help.
Eric

in step3 of the text to column wizard,
define the column as text, not general


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eric" wrote:

Hi There,

I am writing a macro on how to open a text file in excel
in such as way that my file maintain a "number" text as a
text. Please see below for an example:

I want to open this in column as a text NOT a number.

Code IDNO Region
0001 12345 N1234
0002 35353 C3535
.
.
so on.

How do I do that?

Thanks in advance for your help.
Eric

KeepITcool,

I am not doing it in "manual" wizard I am doing this
in "macro" so, what is the command in macro that will
maintain the text column as a text when I open it in excel?

-----Original Message-----
in step3 of the text to column wizard,
define the column as text, not general


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eric" wrote:

Hi There,

I am writing a macro on how to open a text file in
excel
in such as way that my file maintain a "number" text as
a
text. Please see below for an example:

I want to open this in column as a text NOT a number.

Code IDNO Region
0001 12345 N1234
0002 35353 C3535
.
.
so on.

How do I do that?

Thanks in advance for your help.
Eric



.

Eric,

the syntax depends on the number of columns etc
and may be a bit awkward as it requires an array..

try to use macrorecorder and see it you can edit the recorded code.
if you can't fix it.. plse post back with recorded code.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eric" wrote:

KeepITcool,

I am not doing it in "manual" wizard I am doing this
in "macro" so, what is the command in macro that will
maintain the text column as a text when I open it in excel?

-----Original Message-----
in step3 of the text to column wizard, define the column as text, not
general


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eric" wrote:

Hi There,

I am writing a macro on how to open a text file in excel in such
as
way that my file maintain a "number" text as a text. Please see
below for an example:

I want to open this in column as a text NOT a number.

Code IDNO Region
0001 12345 N1234
0002 35353 C3535 .
.
so on.

How do I do that?

Thanks in advance for your help.
Eric



.