Macro problem trying to open workbook

[shrek]

I have a macro that im trying to open a workbook with which is shown below.


Workbooks.Open Filename:="R:\c2c\SUMMARY.XLS", UpdateLinks:=3
Password = "trumpton"
End Sub

The trouble im having is that it keeps asking for the password BEFORE it open the workbook. Can anyone help?

Many Thanks

 

[onlyadrafter]

Hello,

Try something like this, on one line.

Workbooks.Open Filename:="R:\c2c\SUMMARY.XLS", UpdateLinks:=3, writerespassword:="trumpton"

nice password - always preferred Camberwick Green!

 

[shrek]

Tried that but didnt unfortunally work. I assume that I was correct in putting the macro in the workbook where I want to open it from? Unfortunally it still askes for password. Could it be that the workbook its opening is unprotected already? Im just trying to get it so it dont keep asking for the password before it opens it.

 

[onlyadrafter]

Hello,

What happens when you open the workbook manually? Does it ask for a password?

Which workbook is this code in? is it the SUMMARY.xls, or another one?

 

[shrek]

When I open the workbook manually it asks me for the password and when I input it opens the summary workbook ok. The macro is in a workbook called "passacc" which it opens from using a macro button

 

[onlyadrafter]

Hello,

WHen you open the workbook, on the password entry, is it giving you the option to Read Only, If not try

Workbooks.Open Filename:="R:\c2c\SUMMARY.XLS", UpdateLinks:=3, password:="trumpton"

 

[shrek]

Many Thanks

I tried that but it didnt wanna have it unless I typed in something wrong.

 

[shrek]

But it works now.

Many Thanks