Batch Processing Excel Workbooks

Hi all! I’ve taken on some voluntary work for an animal trust and just need some help (if possible) for the second part of my excel problem.

Part one of removing any rows where to totals equal zero or the rows are blanks is complete. See thread link below:

http://www.excelforum.com/excel-prog...ml#post4124298

I have around 60 or so excel workbooks. Each workbook has 9 worksheets named March, April, May etc through to November.

In column BR of each worksheet I have a totals column, cell type is set to general. Each cell concerned contains =SUM. For ex. =SUM(BP13:BQ13). If the cells in this totals column equal the integer zero only (not 3500, 2440 etc) or is blank I would like the whole row deleted. I would like to do the above from row 13 to 350 inclusive.

I know need to apply the above code (see link) so that it executes on around 60 or so workbooks in the same directory.

Any help would be much appreciated.

Jules

Hi. I've created 3 copies of the original file to test the above. They're all in the same directory. Open up one of the workbooks and insert new module, paste in your code and save and close the visual basic editor. I then alt+f8 and select the macro TreatAllFile but it is erroring giving the message:

runtime error 1004
method 'range' of object '_global' failed

Hi, I can't download to this machine the file you attached, and I don't have the toolbox as I'm using 2003 excel.

Hi I can't download to this machine is it not possible to paste any code into the thread?

thank you

Hi I created a new excel workbook and renamed it ToolBox.xls

then inserted a new module and pasted in the code you supplied saved and closed the book.

re-opened it and ran the macro but it's producing the error:

runtime error 1004
method 'range' of object '_global' failed

sorry I dont understand what you mean by statement?

if I go debug it's highlighting the line:

Range("WkPath") = WkPath

Did you create the Named Range WkPath in Cell C2 ?

no sorry I had no idea I was suppose to do that.

Ok in the ToolBox.xls file I created I have selected cell C2 and then in the cell name box called that cell WkPath hope that's right

It's now giving the error:

The macro 'ToolBox.xls!Treat' cannot be found

thanks

It seems to have worked : )

I will check it manually later today on two of the workbooks just to be sure.

I'm not worried about it displaying the files treated in the workbook file, it's actually good to see this there.

Thank you so much I will get back to you just to confirm

wonderful!!!