Linking to Password-required-to-open workbooks

L

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.
 
L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top