Help amending code

Thanks Bob.

For some reason I keep getting the red error line; the "Filename" part
seems to be the problem...?

Steve

Sorry Steve, missed the brackets

On Error Resume Next
Set oWb = Workbooks("September.xls")
If oWb Is Nothing Then
Set oWb = Workbooks.Open(Filename:= _
"\\Statistics\Year 05-06\September.xls")
End If
On Error GoTo 0
oWb.Activate


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve" <crankylemming@aol.com> wrote in message
news:1124270135.353128.184950@f14g2000cwb.googlegroups.com...
> Thanks Bob.
>
> For some reason I keep getting the red error line; the "Filename" part
> seems to be the problem...?
>
> Steve
>

That did it. Thanks a lot, Bob.

Best,

Steve