Thread: runtime error 52 bad file name or number

I'm getting runtime error 52 bad file name or number at the following bit of code:

Code:

If Len(Dir("\\shared.sharepoint.test.net\Reports\" & Format(Date, "mm-yyyy"), vbDirectory)) = 0 Then
    MkDir "\\shared.sharepoint.test.net\Reports\" & Format(Date, "mm-yyyy")
End If

This is only happening on one PC, the rest all work ok?

Hi,

I am also facing the same problem.
This occurs only in one Machine.
It was working fine untill the macro execution was interuppted due to power loss. After that the VBA code started to throw "runtime error 52 bad file name or number" in that Machine.

Regards,
A Shyamala