Hello, I have a macro that some good souls from this forum helped me to make.
This macro opens all excel files on a folder and runs another macro (to organize the columns of the opened file).
All those files come to me as a file without any extension but its a text file, everyday I receive that files and save as excel file so I can run my macro.
But recently I received thousands of files at once and to run my macro I need to save each one on excel format.
The code that opens all the files is this
Please Login or Register  to view this content.
And I need to run this one on each file
Please Login or Register  to view this content.
Or I could just open the file from excel and run this (according to the macro recorder)

Please Login or Register  to view this content.
The answer seem to be obvious but I cant figure how to put this to work.
Sorry for the long and confusing post.