Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Password to Open Linked Files
If you're writing code, then you're opening the workbooks via code, too???
(seems reasonable to me.) Take another look at workbooks.open in VBA's help. You can specify the password on that command. Ricky Pang wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Linked PDF files open briefly and then close | Excel Discussion (Misc queries) | |||
Linked files, one is Password to Modify protected | Excel Discussion (Misc queries) | |||
Input password or open the sheet as "Read only | Excel Discussion (Misc queries) | |||
Password box to remain open after wrong input | Excel Discussion (Misc queries) |