Open Write Reserved Workbook (write reserved password) as Write Access without prompts

[Poenankie]

Excel 2003:
Open Write Reserved Workbook (write reserved password) as Write Access without prompts

Is it possible to open a read only recommended file with code (in another workbook) in such a manner that it does not ask for a password (i.e. the code must supply the password) and
changes can be made to it, without the user being prompted at any time?

The file attribute does not indicate that is read only, and the following code does not help:

SetAttr "ReadOnlyFile.xls", vbNormal

This line will get you past the password:

Workbooks.Open Filename:="ReadOnlyFile.xls", WriteResPassword:="Wagwoord"

BUT you are then prompted to open the file as read only.

Removing the prompt by the following line results in opening the file, still as read only:

Application.DisplayAlerts = False

I can not get the macro to open the file with write access without any prompts.

I will appreciate any help and value your time.

Regards,
Poenankie

 

[BrianMH]

Try adding ReadOnly:=False, IgnoreReadOnlyRecommended:=True

 

[Poenankie]

Try adding ReadOnly:=False, IgnoreReadOnlyRecommended:=True

Thank you, thank you, thank you!

It is working perfectly.

Sub OpenReadOnlyFileWithPassword()

Workbooks.Open Filename:="ReadOnlyFile.xls", WriteResPassword:="Wagwoord", _
               ReadOnly:=False, IgnoreReadOnlyRecommended:=True

End Sub

 

[BrianMH]

Glad to help!