Password on Linked Workbook

[TimPittaway]

I have created an excel workbook (A) that uses data from another, password protected, workbook (B). At the moment I need to open B, with the password, and then open A for it to be able to refresh. Can anyone help me with some VBA code so I don't have to open B, either by (i) asking for B's password when I open/refresh A, or (ii) bypassing the password (or include it in the code) when I open/refresh A?

Thanks.

 

[Dreamboat]

Try this:

http://oldlook.experts-exchange.com:8080/Applications/MS_Office/Excel/Q_20817804.html

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books