Open delimited text file to excel without changing data in that file
 

Hi there,

I need help in opening text delimited file to excel without excel
changing data such as dates or number without heading zeros to its
version.

Right now, I am thinking to write VB macro behind command button, to
set a new worksheet in to text format and get the text delimited file
into that worksheet. Could you suggest how I can do this ? sample codes
will be helpfull too.

Thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Open delimited text file to excel without changing data in that file
 

I think you can record a VB macro when you open the text
deleimted file in excel and modify the macro.

-----Original Message-----
Hi there,

I need help in opening text delimited file to excel
without excel
changing data such as dates or number without heading
zeros to its
version.

Right now, I am thinking to write VB macro behind command
button, to
set a new worksheet in to text format and get the text
delimited file
into that worksheet. Could you suggest how I can do
this ? sample codes
will be helpfull too.

Thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.