Is there a way to show a "count down" like 1 of 100, 2 of 100, 3 of 100 etc.
in excel while excel is running a macro?
I am working in a folder with 100 files, everytime a file is opened by the
macro can a counter be shown what file it is one, IE 1 of 100 etc.

I looked at progress bars, but I don't think I can do that yet.
--
Regards

VBA.Newb.Confused
XP Pro
Office 2007