Excel Macro to open password protected workbooks?

Posted to microsoft.public.excel.misc

DBM[_2_]

external usenet poster

Posts: 4

Excel Macro to open password protected workbooks?

I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Links to password protected workbooks	Nesta777	Excel Discussion (Misc queries)	1	July 19th 06 12:34 PM
Password protected workbooks	Mike Stanley	Excel Discussion (Misc queries)	1	December 15th 05 11:16 PM
How to see macro code of a password protected macro without a password?	Dmitry Kopnichev	Excel Worksheet Functions	5	October 27th 05 09:57 AM
How do I save a password protected Excel doc in order to open?	Stamperfiend	Excel Discussion (Misc queries)	4	August 25th 05 11:56 PM
Can one open a password protected Lotus 1-2-3 (wk4) file from Exce	FCZ	Excel Discussion (Misc queries)	0	January 3rd 05 09:03 PM

All times are GMT +1. The time now is 02:22 PM.

Menu

About Us