Hi,

Note: I have already searched the forum on this, there were few topics on this subject but that did not answer my requirement in full therefore posting a new thread.

I need to export the data from excel to text in a peculiar way. There are several columns in my tabulation with predefined set of rows. The data in each column has to be exported as a text file. i.e. if the sheet has 20 columns with data, then 20 files has to be generated. The first cell of each column contains the file name in which the file has to be exported. And the output file, though is text format, is saved with extension.

Now, i would require a macro to export the data in the sheet to a specific folder with different file names.

Can anyone help? If the above is not clear, please pardon, and let me know i shall explain.