What is a 424 Object req error?

[ghrek]

Hi

I aint got a clue where to start here. Im trying to run a macro and comes up with 424 Object required.

Any Ideas? Macro shown below..

Workbooks.Open Filename:= _
"\\lo-nas01\Passenger Accounts\SHARED\passacc\Excel\passacc\os2020.xlsm"

If Wb.ReadOnly Then
MsgBox "THIS FILE IS READ ONLY"

End If
End Sub

 

[RoryA]

What is Wb supposed to be? If it's meant to be the workbook you just opened, then you didn't assign it. You should use:

Set Wb = Workbooks.Open(Filename:= _
"\\lo-nas01\Passenger Accounts\SHARED\passacc\Excel\passacc\os2020.xlsm")

 

[ghrek]

Tried that and it done want to pen my workbook at all now.

What im trying to do is open the workbook via macro but if someone else tries to get into it I need it to come up with a message box advising "READ ONLY"

 

[ghrek]

Sorry was me. Had put part of the address in lower instead of Upper case... Thanks anyway.