Macro to help update data from protected files

[hamad.fatima]

I need help in creating a macro. I have a master file X1 and it
connects to 55 other files all password protected. When i open the
Master file , it asks the protected fiel to be open to update the data,
otherwise it gives error. Can someone help me create a macro which will
update the data witout opening the protected fiels one by one.

Thanks

 

[Dave Peterson]

I don't think you'll find a macro that can do this.

But what you could do is create a new workbook that opens each of those 55 other
files (supplying the password) and then opens your real workbook.

 

[hamad.fatima]

Is it possible that if I have the lists and location of all the files
in one tab of master file along with thier passwords. Can a macro refer
to that file and update the information automatically.

 

[Don Guillett]

You could do this with a for/each macro


for i= 1 to cells(rows.count,1).end(xlup).row
myfilename=cells(i,1)
mypassword=cells(i,2)


next i