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
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Olinda Roxo" wrote:

how to write in VBA something that searches in a file (archive) a does it
line by line?