appExcel.visible=true
Set objWorkBook = appExcel.Workbooks.Open ("C:\IT_TEam.xls")
Set objsheet = objWorkBook.sheets("Sheet1")
''With objsheet.UsedRange
''Set a = .Find("
For Each a in objsheet.UsedRange
If a = "
a.Interior.ColorIndex = 50
End If
'Set a= .FindNext(a)
Next
'End with
objworkbook.Save
objworkbook.Close
Set appExcel = nothing
No comments:
Post a Comment