Dim App As New MSExcel.Application Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\test.xls") Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1) Dim Rg As MSExcel.Range = Ws.UsedRange rg.Replace(What:="56", Replacement:="A", LookAt:=2, SearchOrder _ :=1, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False) app.visible = True
加好友 
发短信
Post By：2018/9/11 9:54:00 [显示全部帖子]
