Even though this applies to excel, it might be slightly off topic. But
this can't be that uncommon a problem, so I'm hoping someone has
already invented this wheel.....

I need a report with this:
1)Name of spreadsheet
2)Total rows in each spread sheet
3)Total rows on all sheets

I know I can do this manually, but to do this manually on a regular
basis is impractical.
The machine runs under windows, so a shell script is not doable.