Thread: Macro to copy a column data to flat file or text file

Hello Friends
Please can any one help me in writing a macro, which will copy the column data to a text file or flat file, by giving a column name as an input to macro.
i.e. macro [columnname] - it should write that particular columnname to a text file.
Please give some inputs
Thanks
vinay

As we run the macro, with column name as its input parameter, the contents of that column name should write to a regular text file.

I want the data to be copied as it is, before it was in Excel sheet
lets say
My column A has following data
Column A
Peter
Sam
Victor
Nancy

Now when i run the Macro, i e, it should copy the above data into a regular text file
Run Macro A (columnname as input to my macro)
Now the text file should contain the above data
Peter
Sam
Victor
Nancy

Hope you understand
Thanks
vinay