thanks TOM. How to run macros and make the workbooks invisible

  • Thread starter Thread starter christine
  • Start date Start date
C

christine

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.
 
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
 
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.
 
Back
Top