Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a situation.
I have to unzip a spreadsheet and load it in my QV app.
When I searched the forum, I found only the local files can be unzipped.
So, in my case, I have to download the file to local and then unzip it through VBS.
Can you please help with the code? I'm not good in VBS. Thank you.
I meant, I have a spreadsheet in the sharepoint folder, where I access it thru an URL,
So, we have to consider that as Web file.
It is possible. With something like this:
Sub Download
dim xHttp: Set xHttp = createobject("Microsoft.XMLHTTP")
dim bStrm: Set bStrm = createobject("ADODB.Stream")
xHttp.Open "GET", "http://www.colorado.edu/conflict/peace/download/peace.zip", False
xHttp.Send
with bStrm
.type = 1 '//binary
.open
.write xHttp.responseBody
.savetofile "c:\downloads\peace.zip", 2 '//overwrite
end with
End sub
I took this from Stack Overflow thread 2973136 from Alex K.
Hi Arthur,
Thanks. I will check and get back to you..
Hello, generally sharepoint sites also have the UNC drive paths and access the zip folder directly from sharepoint UNC path. Or create small script outside of Qlikview and download the files from share point site to Qlik readable drives and consume data from drive.
If you create the Macro, it won't work while reload the app.
Which version of SharePoint are we talking about? Is it even Office 365 in the cloud?
Hi Petter,
I'm not aware of it. But I can find it out.