VBA to open a password protected workbook

**Larry.LeBlanc@O** · 11-25-2008, 07:37 PM

How can I use vba to open an Excel workbook that has passwords for both opening and for modifying? I think this is close:

Workbooks.Open "Full Path Name", Password: ="XYZ"

However, using that prompts me for a second password (to modify the workbook)

**stanleydgromjr** · 11-25-2008, 08:26 PM

Larry.LeBlanc@O,

You could record a macro from a blank workbook, and open the password protected workbook, and enter the password. Then stop the macro recorder.

Then check the newly recorded macro for the code.

Have a great day,
Stan

bugmenot · 11-25-2008, 09:40 PM

Hi Larry,

Try something along these lines. Replace "Filename" with the file path you are tryinf to open and "Password" with the password required to open it.

Please Login or Register  to view this content.

Cheers

**mattydalton** · 01-02-2009, 08:21 AM

I am attempting to do exactly the same thing and, when I use the sample codes given here I am still getting the box asking for the password for modify access. Any other ideas?

**mattydalton** · 01-02-2009, 08:25 AM

I actually just figured it out:

Please Login or Register  to view this content.

**dominicb** · 01-02-2009, 08:31 AM

Good afternoon Larry.LeBlanc@O

Originally Posted by mattydalton

I am attempting to do exactly the same thing and, when I use the sample codes given here I am still getting the box asking for the password for modify access. Any other ideas?

The reason for this is that the user specified a file open password and a file modify password when the file was saved. The code below will handle both types of password :

Please Login or Register  to view this content.

HTH

DominicB

**Hemant Agarwal** · 11-07-2016, 05:04 AM

I am looking to get code to open a protected excel file for which I lost the password to open, when I tried the above coding it is giving me "Run Time error 1004: The password you supplied is not correct Verify that the caps lock key is off and be sure to use the correct capitalization"

Please help me with VBA code to open a protected excel file which is password protected (to open and to modify)
thanks

**cytop** · 11-07-2016, 05:12 AM

Please read the board rules:
2. Don't post a question in the thread of another member -- start your own.
11. Don't post questions regarding breaking or bypassing any security measure

If you don't have the password then the question will not be answered.

**AliGW** · 11-07-2016, 11:02 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.