I iseek Unregistered / Unconfirmed GUEST, unregistred user! 2006-05-29 #1 我只是想在后台查询某个.xls文件里是否包含一个要找的关键字. word好办,但对付Excel,没有头绪.总不能一个sheet一个sheet、一列一列地去找吧.
Y yuzk2005 Unregistered / Unconfirmed GUEST, unregistred user! 2006-05-29 #3 excelapp.Cells.Find(What:="bbb", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
excelapp.Cells.Find(What:="bbb", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
