Linking to Password-required-to-open workbooks

[Libby]

Hi Guys,

I have a workbook which has links to a number of other workbooks which
require passwords to open them.
The problem is that when the workbook is opened, the user is prompted for
the passwords for each of the protected workbooks that link to it.

Is there any way of updating the links to these password protected
workbooks, or to progammatically enter the passwords without actually opening
the workbooks?

Many thanks in advance.

 

[JLGWhiz]

Based on Tom Ogilvy's remarks at the site link below, the workbooks will
need to be open for the links. That means that to avoid the user having to
enter passwords for each workbook, it would have to be done with the code
when the master workbook opens.

http://en.allexperts.com/q/Excel-1059/Linking-Workbooks-Rules.htm

 

[Libby]

for the benefit of everyone, here is my solution.

I write the values I wanted to link from the workbooks into a text file and
then read those values into the workbook that was to link to the others.