Home » Forums » Open Source Learning Center » Question and Answer

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

Submitted by Aisha on 2 May, 2013 - 10:38

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

‹ Web Query a list of values Logic syntax in excel ›
»
Almir's picture

Send me an e-mail

Submitted by Almir on 3 May, 2013 - 07:47.

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

»