Export columns to text files with different headings

[dualaudio454252]

Please, I need to export some columns from a excel sheet to text files with different headings.

This is the code that I have recorded and changed:

Please Login or Register  to view this content.

The way it is, all 5 columns go to the same file.
And I have to export column A to a file whose name is in M1, column B to a file whose name is in N1 and so on, something like:

Please Login or Register  to view this content.

This structure is very close to what I need and to what I can adapt.

Anyone could help me?

[JBeaucaire]

Based on the way you asked the question, I guess that at some point you might want to specify other specific columns to export and other target cells for the names of each, so in the macro you will find two very basic ARRAYS, one listing the columns to target individually, the other targeting the name cells individually. This should make them very easy to edit should you ever need to:

Please Login or Register  to view this content.

[dualaudio454252]

Thank you, Jerry, it really works, but I got a #REF! error in each line.
The lines cointain formulas (sorry, I didn't mentioned this).

[JBeaucaire]

The macro above has been edited to account for the formulas needing to be removed. Please try again.

[apo]

Hi..

I am not sure if i am 100% on the requirements.. but this is how I am taking it..?

You want to to create a text file that contains each columns values (Columns A,B,C,D,E).. and you want each text file named from the value in row 1 of Column M,N,O,P,Q..

Is that right..?

If so.. maybe this..

Please Login or Register  to view this content.

I have the text files going to a static Directory.. change that to what you want or add a Folder Browser Dialogue..

[dualaudio454252]

Thank you, Apo, but it didn't work for me.
Thanks for your effort.

And Jerry, sorry for the delay (I had to go to work).
Thank you very, very, very much!!!!!!!!!!!!
It's just like I need.
It works perfectly!
You´re the best!

[apo]

Hi dualaudio454252,

Out of interest.. which part of it didn't work?

Did you try the attached Workbook..? and if so.. is the output not what you want..

When i look at Jerrys code.. I was sure the output of my code would be the same..

[JBeaucaire]

Apo, it may be as simple as the path was missing the C:\downloads\ part.

Also, I'd recommend you adjust the RESIZE method to resize each column separately, you've assumed all the columns of data are the same number of rows and there's no basis for that assumption.

Lastly, we typically let the OP go once he settles on a solution, best to not pursue them specifically after the've declared it solved.

[apo]

Yeap.. no worries Jerry.. good idea with having separate resizing for each column.. i missed that one..

Lastly, we typically let the OP go once he settles on a solution, best to not pursue them specifically after the've declared it solved.

Got it.. thanks for the advice..