View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ricky Pang Ricky Pang is offline
external usenet poster
 
Posts: 53
Default Input Password to Open Linked Files

Hello Experts,
How do you write a code that will input the password to open the linked
file as the "Master file" tries to update?
For example:
1) While opening my "Master file", the prompt to Update linked files
pops up. If "Yes" is selected, then input the password "openA" to open
the linked file (File A).
2) On the next linked file (File B), input password "openB"

3) While opening my Master file, if Update linked files "No" is
selected, then end.

Your help is greatly appreciated.

Ricky

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!