Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA
how to write in VBA something that searches in a file (archive) a does it
line by line? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|