View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pennie.thomas@ace-ina.com is offline
external usenet poster
 
Posts: 8
Default excel linked documents password hold in code

hi there

i have a document which links to 14 other documents, which all have
passwords.

i would like to be able to update without having to remember all the
passwords.

does anyone have any idea on how to do this? a way of holding the
passwords in vba?

i think i will have to open and then close each doc as Excel will not
open all of them together.... runs out of memory...
any help! as always gratefully received....

x x x