Using the methods you are using, it has to open your text files (which then
appear as workbooks). If you save and close them after each has been
processed, then they don't necessarily have to be seen. Right now you are
saving them, but you are not closing them

Activeworkbook.Close SaveChanges:=False ( you already saved them, so
you don't need to save again).
or
Workbooks("Hector.htm").Close SaveChanges:=False

as examples.

--
Regards,
Tom Ogilvy



christine wrote in message
...
i have not tested the new codes yet. Basically, i run th
macro that contains 10 processes within a workbook called
test. I am fine with it opening test. But i do not want
it to open all ten workbook when it is run.