Convert Multiple text files to excel files

1) Turn on your macro recorder.
2) Open one of your text files and convert it/save it as XLS
3) Open a second text file and convert it/save it as XLS
4) Turn off the macro recorder

5) Press Alt-F8 to open the macro list
6) Click once on your recorded macro and select EDIT
7) Copy that code into memory

8) In the forum QUICK REPLY box below, click GO ADVANCED
9) Click the # icon
10) Paste in the code you copied between those code tags

We'll take a look and offer replacement code that will open/convert all the files in that folder for you based on what we see in your recorded macro.

hello sir, i have to convert 1200 text files to individual excel files. i have done according to your post and sending you the macros code. please look at it and let me know for further processing.

Please Login or Register  to view this content.

Normally it is against the rules to HIJACK someone else's thread with a question of your own. In this rare instance the OP has abandoned the thread, so we'll let you take it so as to complete the usefulness of the thread's existence. But be warned, as this is your first post I suspect you might nit have read the rules you agreed to abide. Take a moment and read them now, there's a link to the Forum Rules in the menu bar above.

============
Based on your sample, this should process all the files in the given fPATH:

Please Login or Register  to view this content.