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

**vinaynagasani** · 06-26-2009, 04:44 PM

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

**shg** · 06-26-2009, 05:50 PM

A particular text file?

Data limited in what fashion?

**vinaynagasani** · 07-01-2009, 10:20 AM

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.

**vinaynagasani** · 07-01-2009, 10:56 AM

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