Pass A Password To A Protected Workbook

[markkramer]

Unlike the posts that I've located on the site, I actually know the password of the workbook I'm trying to open! My question is how to pass that password to the workbook in my code so that the user is not bothered with having to enter in the password (I don't want them to know it anyway).

I tried this combination but that didn't do the trick:

Workbooks.Open Filename:="myworkbook.xls"
ActiveWorkbook.Unprotect Password:="abcd1234"

Somehow I need to open the workbook and pass the password at the same time.

Thanks for you help!

M

 

[markkramer]

Wait! One of my coworkers just figured it out. Here's the command:

Workbooks.Open Filename:="myworkbook.xls", Password:="abcd1234"

That opens the workbook and passes the password all in one command. And no dialog box!

Thanks everyone for all your help!

M

 

[erik.van.geit]

Markkramer,
(didn't feel bad, be sure, didn't had the feeling you threw me off)
You are making clear to everyone what pennysaver already understood
in fact your workbook is protected from the "outside": so you need to undo the protection of the file itself
Workbooks.Open Filename:="myworkbook.xls", Password:="abcd1234"

regards,
Erik

EDIT: what a quick thread (quicker than me inventing english words!)