network document not opening with macro

[smakatura]

I am trying to open a document with vba. below is the code I have.

while no getting a error message, the document no opening. I tried "o:" and \\dfs.com\root\

   Dim Open_Aspect_Sheet_Check_Open As String
    Dim xWb As Workbook
    On Error Resume Next
   
    Set xWb = Application.Workbooks("Aspect Inbound Stats (All).xlsx")
   
    If xWb Is Nothing Then
        Workbooks.Open Filename:="O:\Operational Reporting\Aspect\Aspect Inbound Stats (All).xlsx, ReadOnly:=True"
    Else
        Windows("Aspect Inbound Stats (All).xlsx").Activate
        ActiveWorkbook.Close savechanges:=False
        Workbooks.Open Filename:="O:\Operational Reporting\Aspect\Aspect Inbound Stats (All).xlsx", ReadOnly:=True
    End If

 

[RoryA]

You have the quotes in the wrong place:

        Workbooks.Open Filename:="O:\Operational Reporting\Aspect\Aspect Inbound Stats (All).xlsx", ReadOnly:=True

 

[smakatura]

thanks, I fixed the quotes, but is still saying can not find and asking if it has been moved

 

[smakatura]

That worked . it just hiccupped for a second (you can ignore the error comment).

Thanks