Prev: Side Filter
Next: mouse pointer to be focused on userform command button upon opening
From: Richard on 26 Feb 2010 09:30
I'm looking for macro functions to upload and download files to SharePoint
file sharing site - and I'm running a gov computer with a CAC card, so I
don't use user login and passwords to access the SharePoint site

I found this code, but is doesn't work:
Function WebUploadFile(file, url, user, pass)
Dim objXMLHTTP
Dim objADOStream
Dim arrbuffer
Set objADOStream = CreateObject("ADODB.Stream")
objADOStream.Open
objADOStream.Type = 1
objADOStream.LoadFromFile file
arrbuffer = objADOStream.Read()
Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objXMLHTTP.Open "PUT", url, False, user, pass
objXMLHTTP.send arrbuffer
End Function
--
Richard
 | 
Pages: 1
Prev: Side Filter
Next: mouse pointer to be focused on userform command button upon opening