Open File - VBA

[mcarter973]

I have a macro that opens a file and will find/replace values -- the file will then close quietly. Is there a way to run the macro w/o the file opening/closing - this process seems inefficient?

Thanks.

Workbooks.Open FileName:= _
"R:123.xls"
For Each myExample In Range("A:A")
If myExample.Value Like "123*" Then
myExample.Value = "test"
End If
Next myExample
.
.
.
.
.
ActiveWorkbook.Close False
End Sub

 

[Juan Pablo González]

Actually the inefficient part isn't the opening/closing, is that you're looping through 65536 cells ! use the .Replace method instead.