Macro to Loop Through Full Folder of TXT files

Hi All,

I have a macro:

Please Login or Register  to view this content.

I would like to do the following:

• Open a main workbook
• Click a button to run a macro
• Select a folder in a window
• Open each TXT file in this folder and run the above macro on all TXT files

I would also like to add a few lines to the end of the macro to save each TXT file as an XLS file. Can anyone assist me with this?

Many Thanks
dvent!

You might need to tweak your Edit routine a bit.

Please Login or Register  to view this content.

Hi Kenneth! That's great.

Is there a way to add one feature to the end of this macro to print all of the XLS files once they are produced?