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.

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.

Thanks tom, But i do not need to save them all i want is
clean up the text file and save them as web file. then
the next text , then the next text. i do not want the
excel itself. i just use excel to clean up the text files.
Thanks again
-----Original Message-----
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.


.

You still seem to be missing basic concepts. You open the text file in
excel and it is opened and treated like a workbook. You process it and then
save it as html. The html file still sits in excel appearing as a workbook
until you close it. All files displayed in Excel are displayed as/appear as
workbooks regardless of the actual format of the underlying file.

--
Regards,
Tom Ogilvy

wrote in message
...
Thanks tom, But i do not need to save them all i want is
clean up the text file and save them as web file. then
the next text , then the next text. i do not want the
excel itself. i just use excel to clean up the text files.
Thanks again
-----Original Message-----
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.


.