Kill statement does not work in Sharepoint

Asked Jul 26 '17 at 13:25

Active Jul 26 '17 at 13:44

Viewed 257 times

Calculations kept by users are stored as "ToCheck..." on sharepoint. Once checked the file is than renamed to "Checked...". I am trying to delete the now superfluous "ToCheck..." file. First this code: Dim spMap As Object, spPath As String

Set spMap = CreateObject("WScript.Network")
spMap.MapNetworkDrive "X:", spPath
DoEvents

Kill (Pad & Naam)

. .

and later other code from internet (after ticking in tools/references MS scripting)

Dim fs As New Scripting.FileSystemObject
With fs
    If .FileExists(yourfilepath) Then
        .DeleteFile yourfilepath
    End If
End With
.
.

edited Jul 26 '17 at 13:44

ThunderFrame

9,352
2
29
60

asked Jul 26 '17 at 13:25

JohnnyDutch

What does it do instead of working? In the second example does the `DeleteFile` line actually run? – Tim Williams Jul 26 '17 at 16:13
nothing. But I found code that does work: https://stackoverflow.com/questions/12955831/deleting-sharepoint-files-using-xmlhttp – JohnnyDutch Jul 28 '17 at 06:30

Kill statement does not work in Sharepoint

0 Answers0