I had to print loads of charts from excel files. All at once! Rather than starting printing one by one I started looking for software to do the job for me. I found some really nice featured software but they came with hefty price tags (not less than 100 bucks). At last I found just what I want. A free, easy batch printer for Excel, batprint.xla!
But the only problem with it is all files need to be opened before printing. But, that is ok with me as I can select each sheets I want to print (the feature some paid software do not have).
If you want the tool you can download it from
The page has detailed instruction on how to install and use it.
I have a copy of it. If the link cease to work I can always upload for you.