.txt to Excel vba Macro

Hi
I have a .txt file which i have to import to excel & the data will be seperated by comma (,)
.txt file name is NseVar.txt
Hardcode the path & name of the file in the code only so that i will change it as per my needs

& the file name where we have to import the .txt data is NseVar.xlsx & plz hardcode the path & name of the file also in the code only so that i will change it as per my needs
Note :NseVar.xlsx is not opened so we have to open it & then we have to import the data from NseVar.txt


Thnx for the Help

How about

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I got the macro But there is a little change needed in this macro, Macro will be placed in Master.xlsm & the file where data should be imported is NseVar.xlsx so liitle change is needed
So plz help in modifying the same in the code

The macro I posted, will create a file named NseVar.xlsx. Output is exactly the same as yours.
Did you test it?

No Sir bcoz the code will be placed in master. Xlsm & data has to be imported to NseVar.xlsx, So ur code is not doing the way i am looking for

Ok how about this?

Please Login or Register  to view this content.