run -time error '52' HELP!!

[jhon53]

Hi there I'm new to macros and I'm having some trouble with this error 52 coming up every time I hit run, it does occur if I end my one drive I don't know why this is happening any help is appreciated.

 

[DanteAmor]

Hi and welcome to MrExcel!
Try this

Sub initLog()
  With ThisWorkbook
    If .Sheets("Debug").Cells(2, 2).Value Then
      If Dir(.Path & "\Logs\", vbDirectory) = "" Then
        MkDir .Path & "\Logs\"
      End If
    End If
  End With
End Sub

Note: Enter the code using the icon for codes

 

[jhon53]

I still get the same error

 

[DanteAmor]

error 52

What does the error message say?

 

[jhon53]

bad file name or number

 

[jhon53]

its highlighting the 4 row

 

[DanteAmor]

Check if the following helps you:

Runtime Error 52 Repair Tutorial

- Runtime Error 52 shows up to alert you that your PC has a bad number or file somewhere in its system, and as a result, it cannot run the file it needs to

www.personalcomputerfixes.com