Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
Function CreateFolderStructure(ReportType As String, Archive As String, customer As String)
Set wsd = Sheets(shtData)
'Country
Archive = wsd.Range(ctEntity_Cnt)
Call CreateDir(Archive)
'Customer
Archive = Archive & "/" & customer
Call CreateDir(Archive)
'Report Type
Archive = Archive & "/" & ReportType
Call CreateDir(Archive)
End Function
Function CreateDir(ByVal sDir)
On Error GoTo Errorhandler
Dim xmlhttp As MSXML2.xmlhttp
Set xmlhttp = CreateObject("MSXML2.XMLHTTP.3.0")
strUrl = SharePointUrl & sDir
xmlhttp.Open "MKCOL", strUrl, False
xmlhttp.send
Set xmlhttp = Nothing
End Function
Function SendToSharePoint(ByVal sFilename, sType, Archive)
Dim xmlhttp As MSXML2.xmlhttp
On Error GoTo Errorhandler
sData = getFileBytes(sFilename, sType)
sFilename = Mid(sFilename, InStrRev(sFilename, "\") + 1, Len(sFilename))
Set xmlhttp = CreateObject("MSXML2.XMLHTTP.3.0")
strUrl = SharePointUrl & Archive & "/" & sFilename
xmlhttp.Open "PUT", strUrl, False
xmlhttp.send sData
If xmlhttp.statusText = "Created" Then
SendToSharePoint = True
Else
SendToSharePoint = False
End If
Set xmlhttp = Nothing
Exit Function
Errorhandler:
SendToSharePoint = False
End Function
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.