I have tab delimeted files i need to run against my other software.
Po box,123,utah
Lexing,568,ohio
Pixar,245,new york
I need to say if T3=Utah then open software if T3=ohio then open notepad else close
I can make macro run 1st row (utah) but how do i tell it to go next row to see ohio and new york? My macro just repeat the same row over and over again which is utah.
Please help