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
Bookmarks