I have created a workbook to summarize data from other workbooks. In order
to accomplish this task, I linked data using formulas. I am trying to create
a macro that updates the links. Here's the catch, all of the other
workbooks that are linked have open passwords. So when I update the links I
have to key in multiple passwords. I am trying to get around this by simply
using vba to open up all the linked workbooks and then close them. However,
when I do this, the links do not update...any help on this would be
appreciated. End game, is I do not want to have to key any multiple
passwords everytime I need to update links...I would rather have code to that
for me.