Office 365 and Cloud error 052

[Guus2005]

I have taken over a small Excel application to store Child Care information; Who is here, when and how much money do i get.
When they install the app on a system with a full office version there is no problem. However when they install it on office 365, some, not all, clients get an error message.
When there is an error message a log file is created. On office 365 they get an error message stating they can't write on

"https://d.docs.live.net/b696908098/.../Documenten/Appv2020\Appv2020.LOG"

Obviously they are using some cloud service. Storing documents on their Documents folder is completely transparant.
Is there a way to circumvent this kind of behaviour?

Thanks,
Guus

 

[Isaac]

What is the code to create the log file of errors?

 

[Guus2005]

    gstrBestand = ThisWorkbook.Path & "\KSM.LOG"
    If Dir(gstrBestand) = "" Then
        Open gstrBestand For Output As #1
        Print #1, "Logbestand van KSM"
    Else
        Open gstrBestand For Append As #1
    End If
    Print #1, " " 'Spatieregel
    Print #1, Format(Now(), "dd-mm-yyyy")
    Close #1

 

[Minty]

On office 365 they get an error message stating they can't write on

"https://d.docs.live.net/b696908098/.../Documenten/Appv2020\Appv2020.LOG"

If you look closely there is a backslash near the end of the string by the file name - pretty sure that won't work?

 

[Isaac]

If they insist on opening the workbook from a cloud-based path which they also don't (apparently) have permissions to create a new file on...then I would change:
gstrBestand = ThisWorkbook.Path & "\KSM.LOG"

to some other location on their machine, maybe %appdata%\something