VBA

  • Thread starter Thread starter Olinda Roxo
  • Start date Start date
O

Olinda Roxo

how to write in VBA something that searches in a file (archive) a does it
line by line?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How open notepad.exe and write text line by line via excel vba? 2
VBA and SOAP in Excel 2010 0
How write into text file at first and last line with excel vba? 3
Change the slope of line graph with the use of spinbutton in Excel VBA 1
VBA's Q? Printing None-Zero Valye ONLY 1
Save Text to File 3
text wrapping in coding lines 2
VBA Code Writing to Excel Box Name 3

Back
Top