Calling macro on multiple .txt files

[CrazyHorse]

hi all,

I have a folder with 1000 .txt files, and on those i created a macro which after doing all the things needed saves the files as .txt. (I did the macro using the 'recrod macro' function).

Now I need a way to create a macro that opens all of those 1000 files, do the macro i created and closes the files, and so on till all are done

I tried sone macro found on the web for example these 2:

http://www.eggheadcafe.com/microsoft...ple-files.aspx

http://www.ozgrid.com/forum/showthread.php?t=28981

but both doesnt work .

Thank you a lot for helping^^


Ok seems I solved it, one of the 2 links above worked, i think first time i tried it i had done something wrong^^

ty anyway