Something like

sub test
dim doc(1 to 6) as string
doc(1)= "file1 name"
doc(2)= ..
....
for x =1 to 6
workbooks.open doc(x)
...
workbooks(doc(x)).close True
Next
Untested
Regards
JY

"CmK" wrote in message
...
Progrssive indicator?

"Bob Phillips" wrote:

What progression display?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"CmK" wrote in message
...
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