Opening Text File Delimited Carat(^) separator

It depends on the structure of your ext file.

One way is that you could create Schema.ini file in the folder and read through ADO something like "Format=(^)".
Otherwise, read the contents and split the output...

hi sir,
actually text file format is very simple
below is the contain of text file.

Please Login or Register  to view this content.

and in this case i have to pick the G2:G & end and K2:K & end data and paste sheet1 so there is no need to split the data.
below are the steps which i follow
steps:
open text file
copy 2 columns and paste in sheet1
close text file
open new one
copy 2 columns and paste in sheet1 (leave 1 row and then paste)
loop so on

Originally Posted by mohan.r1980

but i stuck in opening the text file with carat separator (^)

Isn't that your problem?

Not really sure though

Please Login or Register  to view this content.

Thanks Jindon Sir,

i just want to know the parameter of carat separator

i trried

Please Login or Register  to view this content.

but you show me the right parameter
i.e.

Please Login or Register  to view this content.

it open the text file but in general form not in text form. its ok i will make it as text

thanks again sir.

If you use "Workbooks.OpenText", it opens through Excel, not by a text editor.
Do you want to read it sequentially, seemlessly?

If so, my first reply.

Hi Sir,

i record the macro and get the syntax it looks like below:

Please Login or Register  to view this content.

it works

thank you sir