View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default txt file from filtered data

Text file is ambibuous. Do you want comma delimited, tab delimited, fixed
column?

Do you just need to be prompted with
Use Autofilter, then build the textfile using low level file io

http://www.applecore99.com/gen/gen029.asp

or do you need someone to put up example code?

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
I have a worksheet that has 6 columns. The number of rows can vary. I

need
to filter the worksheet on 3 of the columns to narrow the data down to

what I
need to extract. Then I need to create a text file using the filtered

data
so that cells A1, B1, & C1 are on a line and then D1, E1, & F1 are on the
next line. I need to repeat this in the text file for each row in the
filtered worksheet. Is this possible?