text insert layout error

Hello,

Instead of creating a macro, why not use excel build in feature to save the query.

Once the query is saved, in whatever desired format u saved it.... you just hav to open any excel file.. click on data -> Run query and excel will automatically fetch the data in desired format from the text file


Else if u want to go ahead with your approach then use the the following
Destination:=Range("A2")

Instead of
Destination:=Range("A2:N2")

Perhaps change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.