If you mean you want a progress bar to display how your code is progressing
then something like at the end of the link below could be incorporated into
the workbook that contains the code to do all the opening and closing.

http://www.cpearson.com/excel/Progress.htm

"CmK" wrote:

I want to use the progression display while it is opening 6 different files
then refresh them then close them
I am hoping there is a way to do this through a loop
bUT CANT FIGURE OUT how to open different files names in the loop

thanks in advance