password & Links

[Martel]

Workbook A has been opened with a password.
Workbook A opens Workbook B from VBA code module with:
workbooks.open filename:="C:\excel\Workbook B.xls", password:="OPENME"
Workbook B has a link to a cel in Workbook A.
When Workbook B opens, I am prompted for the password for Workbook A, which
is already open. Can anyone explain this please?

 

[Dave Peterson]

I would open workbookb.xls manually (with workbooka.xls closed)

Then I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

to see if there is a link to another file with the same name, but in a different
location.

(Just a guess.)

 

[Dave Peterson]

Or you could use Edit|Links (xl2003 menus) to look for the links, too.

 

[Martel]

My thanks to Dave Peterson. I tried Bill Manville's FindLinks utilty - very
useful, although it did crash Excel once - but no surprises. It found the
one valid link I was expecting - to Workbook A and in the correct location.

To prove the connection between the link and the password, I tried deleting
the link. That worked, but without the link, Workbook B is as good as
useless.

I see LauriS is working with a similar problem. I also tried the suggestion
in reply by Jim Cone to set UpdateRemoteReferences = false, but to no avail.

Conceptually, I see no reason not to open a password protected file from VBA
and have a link from that file to the first one. Give that Workbook A is
already open anyway, why should this be an issue?

I begin to suspect that this is a "design feature", colloquially known as a
bug, built into Excel by Microsoft which they have omitted to mention -
unless anyone out there knows different?

thanks again and still hoping

Martel
--
Martel

Or you could use Edit|Links (xl2003 menus) to look for the links, too.