Re: Linked files and file protection.
From: Tony Prynne (tony_at_prynne.demon.co.uk)
Date: 02/11/04
- Next message: Haz: "importing"
- Previous message: shawn modersohn: "Re: return last value>0"
- In reply to: Dave Peterson: "Re: Linked files and file protection."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Feb 2004 21:51:04 +0000
Thank you for the thread, Dave. And the warning. I guess that I will
be safest just entering the passwords.
In article <402984D7.92F56901@msn.com>, Dave Peterson <ec35720@msn.com>
writes
>About the closest thing you can do in VBA for the passwords is to keep track of
>them and use sendkeys to enter them in the dialog that pops up.
>
>Here's a link with a small example that uses the same password for all the
>linked files:
>
>http://groups.google.com/groups?threadm=3F2B24F4.2ABF9875%40msn.com
>
>Tony Prynne wrote:
>>
>> I have some 50 individual workbooks that provide information to a single
>> Report workbook. All files need to be open protected. The
>> application works fine except that the Report file prompts for the
>> password for each of the 50 linked files when opened with links
>> updating, which is pretty tedious and not necessary. Is there a way of
>> overriding this. It occurs to me that a possibility may be to open
>> Report without updating links, and then update links with a macro with
>> passwords embedded. But my macro skills are not quite up to this!
>>
>> Many thanks for help.
>>
>> --
>> Tony Prynne
>> 3 Richard's Crescent
>> Old Warden, Biggleswade
>> Bedfordshire SG18 9HL
>> Tel: 01767-627688
>
- Next message: Haz: "importing"
- Previous message: shawn modersohn: "Re: return last value>0"
- In reply to: Dave Peterson: "Re: Linked files and file protection."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
