1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
function ActualiserAttaches() as boolean
Dim arrTablename As Variant, arrSourceName As Variant, strSite As String, i As Long
arrTablename = Array("Activités", "Sorties")
' ne pas mettre UserInfo, c'est rajouté automatiquement
arrSourceName = Array("{****995E-****-****-****-30698C68****}", "{****2B85-****-****-****-70F4843F****}") ' , "{****51AD-****-****-****-867E0287****}")
strSite = "https://xxx.sharepoint.com/sous-site"
For i = LBound(arrTablename) To UBound(arrTablename)
' supprimer la table avant tout, sauf si elle n'existe pas
On Error Resume Next
CurrentDb.TableDefs.Delete (arrTablename(i))
'
On Error GoTo ActualiserAttaches_Err
DoCmd.TransferSharePointList acLinkSharePointList, strSite, arrSourceName(i), , arrTablename(i), False
Next i
ActualiserAttaches = True 'la fonction est réussie
Return
ActualiserAttaches_Err:
MsgBox "Erreur " & err.Number & " (" & err.Description & _
") dans ActualiserAttaches - " & arrTablename(i), vbCritical
Return |
Partager