Code to open multiple password protected workbooks

=?Utf-8?B?c2hvcnRpY2FrZQ==?=

Guest

Posts: n/a

11th Oct 2007

I would like to use a macro to open multiple password protected workbooks.
Say that the paths to each workbook are listed in cells A1:A10 and their
corresponding passwords are listed in cells B1:B10.

I would greatly appreciate it if anyone is willing to offer some help with
this code!!

« Optimizing transferring values | Help with sorting issue?? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open Multiple Password Protected Workbooks with Macro	ScottMSP	Microsoft Excel Programming	2	1st Apr 2008 05:27 PM
Excel Macro to open password protected workbooks?	=?Utf-8?B?REJN?=	Microsoft Excel Misc	3	30th Mar 2007 04:48 PM
open a password protected Zip file in C# code.	connoisseur.infotech@gmail.com	Microsoft C# .NET	10	22nd Feb 2006 08:28 PM
Module to import Multiple workbooks when Sheet is password protected	DoctorV3774 via AccessMonster.com	Microsoft Access VBA Modules	0	22nd Apr 2005 01:16 PM
linking to multiple password protected workbooks	Jay Oken	Microsoft Excel Programming	1	19th Mar 2005 01:06 AM