Convert txt to Excel files

[fatalcore]

Hi Friends,
I was wondering if somebody can please help me out with a vba code that will convert all the txt files to seperate excel file by importing the data seperated by delimited (|) in a folder. For example if there are 20 seperate txt/csv file in a folder, i would like to have 20 seperate excel files in the same folder.It will be great if somebody can please help me out.
Kind regards,me

[xlbiznes]

Post a sample txt/csv file.

[fatalcore]

Hi, The files are all different in it's content. But the dilimited parameter is same that is "|" in all the files. However it looks like this.

USERNAME |PASSWORD |USER_ID |ACCOUNT_STATUS |LOCK_DATE |EXPIRY_DATE |DEFAULT_TABLESPACE |TEMPORARY_TABLESPACE |CREATED |PROFILE |EXTERNAL_NAME
SYS |DB Password| 0|OPEN | | |SYSTEM |TEMPORARY |2005/10/04 12:43:51|SECPROFILE |
SYSTEM |DB Password| 5|OPEN

thanks and regards,me

[xlbiznes]

I guess i already have something done on this line. Let me check !

[HaHoBe]

Hi, fatacore,

maybe like this:

Please Login or Register  to view this content.

Please note that the text files will get moved to a subfolder in the given Drive and Folder - you would need to adjust that as well ior comment that out.

Ciao,
Holger

[xlbiznes]

Attached is my solution. Hope this helps.