macro to compile data from diff. excel files in a text file and pipe as a delimiter

I have a folder with around 100 excel files, all in the same format. I want to write a macro which can collect a heading from these files and also the data and save as a text file wiht pipe as delimiter. can someone help me please.

This is a bit urgent

Almir's picture

Send me an e-mail

Send me an e-mail to: almir.budalica@gmail.com. I think I can help you.