Macro to collect data from multiple excel files N store in a text file with pipe 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

can someone please help

Also at http://www.ozgrid.com/forum/showthre...989#post662989

u mean to say i cant get help from other forum?

I'm simply alerting users to the fact you also posted this on OzGrid. I believe the rules here are similar to the rules on OzGrid in that you are required to include links to cross posts on other forums. You omitted to do that, so I did.