VBA Open, Update Links, Password to Modify

[LEVICC01]

Hi guys,

Any ideas why this doesnt work. I've used before, but ive added in UpdateLinks, which has stopped it. But it works if i dont have the password bit, so not sure why the combination is failing.

Workbooks.Open ("filepath.xls"), UpdateLinks:=False, , , "Password"

 

[Richard Schollar]

Is that a writereservepassword? If so, it's in the worng place (sequence). I would use a NamedArgument (as you have for UpdateLinks then you can do without the extra commas:

Workbooks.Open "filepath.xls", UpdateLinks:=False,WriteReservePassword:="Password"

 

[LEVICC01]

Hi,

Not sure what one of those is to be honest.
I have tried it and get the following error:
Names argument not found.

I saved it with a password to modify.
I'm using another file to launch all my reports, and i want the code to open it and type the password in for me

 

[Richard Schollar]

That would be because I got the named argument wrong! Should have been:

Workbooks.Open "filepath.xls", UpdateLinks:=False,WriteResPassword:="Password"

 

[LEVICC01]

Hi,

it says the password is incorrect, but it isnt? Would this be referring to a different password tot he Modify one?

 

[Richard Schollar]

What exact code are you using? Is it a password to open that you are using rather than a writerespassword? What happens when you open the workbook directly in Excel - what messages do you see and what do you type in in response?

 

[LEVICC01]

If i open i get a Password box come up:

Says that is is reserved by me, Enter password for Write Access, or open Read only.

There is a box for the password and 3 buttons:
Read Only OK Cancel

 

[Richard Schollar]

What happens if you just use this code?

Workbooks.Open "filepath.xls", UpdateLinks:=False

 

[LEVICC01]

Hi,
If i use that bit, it works fine but not now i put a password on it. Same as if i opened from the file location manually, i get the password box.

 

[Richard Schollar]

Yes but what password are you typing in to open it? And is it successful?