Open Password protected workbook via VBA in another workbook

[janegrace]

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.

 

[phantom1975]

Try this out:

Workbooks.Open Filename:="C:\Hello.xls", Password:="OpenSesame"

 

[janegrace]

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

 

[phantom1975]

GOod thing newbies are your favorite (your favorite what -- dinner? Hmm, braised newbies with raisin sauce....Hmmmm)

Too funny! Here's what you need instead:

Workbooks.Open Filename:="C:\Hello.xls", ReadOnly:= True

 

[janegrace]

YES! Perfect! Many thanks! (Enjoy your newbies tonight!)

 

[Jack in the UK]

+

.