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
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