Macro mistake.

[Abhinav]

I have about 200 workbooks in a folder with coloumn C
containing quantity of a product.
I have one main excel file, in which quantity is added
everyday and a macro is run which insets the quantity in
individual workbooks respective. Few days back i did run
macro and forgot to check cells filled with value 0 which
i normally used to remove. Now some of those 200 workbook
contain 0 in coloumn C. Is there any function/macro that
would look in coloumn C of all 200 books and display the
books, so that i can open them and delete the row that
contains 0 as quantity?
My workbooks are named as per product name. IE: Body
Lotion, Hair Dryer, ETC ETC and i have a list of all books
in a coloumn. I can add .xls as extension to them if your
macro is goona have to look in product.xls for the 0
value... ummm just confused and need help. Cant open
everybook and check for 0 in coloumn C which has about 100
entries.
Thanks a lot.

 

[Don Guillett]

If you have a list you can do a for each macro
for each wb in range("rangewithlistnames")
open it
'and a for each within each wb
for each ws in worksheets
'delete the rows with 0 from the bottom up
next
next wb