how to write in VBA something that searches in a file (archive) a does it line by line?
O Olinda Roxo Oct 19, 2008 #1 how to write in VBA something that searches in a file (archive) a does it line by line?
S Sheeloo Oct 19, 2008 #2 Once you get the file open and activate the sheet to search for Cells.Find(What:="test", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate
Once you get the file open and activate the sheet to search for Cells.Find(What:="test", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate
