Re: Linked files and file protection.
From: Dave Peterson (ec35720_at_msn.com)
Date: 02/11/04
- Next message: Dave Peterson: "Re: opening a txt file in exce and losing decimal places."
- Previous message: Dave Peterson: "Re: Out of memory error"
- In reply to: Tony Prynne: "Linked files and file protection."
- Next in thread: Tony Prynne: "Re: Linked files and file protection."
- Reply: Tony Prynne: "Re: Linked files and file protection."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Feb 2004 19:26:47 -0600
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
-- Dave Peterson ec35720@msn.com
- Next message: Dave Peterson: "Re: opening a txt file in exce and losing decimal places."
- Previous message: Dave Peterson: "Re: Out of memory error"
- In reply to: Tony Prynne: "Linked files and file protection."
- Next in thread: Tony Prynne: "Re: Linked files and file protection."
- Reply: Tony Prynne: "Re: Linked files and file protection."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
