View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nondisclosure007@hotmail.com is offline
external usenet poster
 
Posts: 7
Default looping in vba for excel

What I'm looking to do is write to a
file the specific rows I sorted on. One record per line.

I know, it sounds re-dundant, but it's part of a larger picture.

fyi. the column value for the records I need write is x. if there's
an x in that comlumn for a record, write the record to a text file.


Now, since it's been over a decade since I last coded, I can't figure
out to start with what kind of loop to do. For, while, etc. And how I
read from the Excel spreadsheet.

Thanks in advance.
-Michael

Psuedo code:
For each row with column "T"="x" Do
Write row to c:\sorted_data.txt
End For