View Single Post
  #4  
Old 07-01-2009, 11:56 AM
vinaynagasani vinaynagasani is offline
Registered User
 
Join Date: 26 Jun 2009
Location: US
MS Office Version:Excel 2003
Posts: 7
vinaynagasani is becoming part of the community
Re: Macro to copy a column data to flat file or 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
Reply With Quote