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

Z

zohanc

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
 
B

Bill Li

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Import a comma delimited file & match records 3
Export data to Text file without leaving worksheet. 1
Import Text file Data into Excel Sheet 3
Create delimited file 0
Import Data, using a command line switch 1
problem with ActiveSheet.QueryTables.Add for text file 0
Save file as Tilda Delimited without spaces or commas between colu 7

Top