I'm using one workbook (A) to contain VBA which needs to open another workbook (B). The workbook B has a password (to modify -- the password was applied via SAVE AS, TOOLS, GENERAL OPTIONS, Password to Modify) I can't seem to get the syntax right in the VBA to open workbook B by supplying the password as part of the WORKBOOKS.Open Filename:="C:\thatfile.xls" statement.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Open Password protected workbook via VBA in another workbook
- Thread starter janegrace
- Start date
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
Try this out:
Workbooks.Open Filename:="C:\Hello.xls", Password:="OpenSesame"
Workbooks.Open Filename:="C:\Hello.xls", Password:="OpenSesame"
Upvote
0
What that causes to happen is I get the prompt box where I can choose to enter the password, or choose 'readonly.' And actually, as I did that, I realized that what I really want is for the VBA to open the file READONLY -- I don't want the password to be used. SO I asked the question backwards. GOod thing newbies are your favorite (your favorite what -- dinner? Hmm, braised newbies with raisin sauce....Hmmmm) By the way, I have
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Thank you for your quick response! JG
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Thank you for your quick response! JG
Upvote
0
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
janegrace said:
Too funny! Here's what you need instead:
Workbooks.Open Filename:="C:\Hello.xls", ReadOnly:= True
Upvote
0
Similar threads
- Solved
