I've built this into the MouseTrax File Cataloger tool at
http://www.mousetrax.com/downloads.html. The code for the progress bar,
calculating percentage and updating the progress bar is all ready for open
and indiscreet theft at your leisure. And it will work in Excel as easily as
in Word. It's clean and accurate. Tasty, in fact.