(Excel) Delete File

Permanently deletes a file owned by the user without moving it to the trash. If the target is a folder, all descendants owned by the user are also deleted.

See Google Drive Files delete for more information.

Download Excel Class Modules Chilkat Excel Class Modules

success = True

' It requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' This example uses a previously obtained access token having permission for the 
' Google Drive scope.

Dim gAuth As Chilkat.AuthGoogle
Set gAuth = Chilkat.NewAuthGoogle
gAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect using TLS.

bAutoReconnect = True
success = rest.Connect("www.googleapis.com",443,True,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
Dim success As Boolean
success = rest.SetAuthGoogle(gAuth)

' To delete a file, we must use the fileId.
' This must've been obtained by listing or searching for the file
' to get the metadata.
' Assume we already did that an have the fileId

fileId = "0B53Q6OSTWYoldUprZVU1ZVQ5Z0k"

Dim sbPath As Chilkat.StringBuilder
Set sbPath = Chilkat.NewStringBuilder
success = sbPath.Append("/drive/v3/files/")
success = sbPath.Append(fileId)


jsonResponse = rest.FullRequestNoBody("DELETE",sbPath.GetAsString())
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 204 and the response body is empty.
' (If not successful, then there should be a JSON response body with information..)
If (rest.ResponseStatusCode <> 204) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response JSON: "; jsonResponse
    Exit Sub
End If

Debug.Print "File deleted."