Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I have one Zip folder (.zip)
How to create a .vbs file and how to load into Qlikview ?
here i am attaching zip folder, VBS_File
Note : It will not work in Qlikview
Thanks
Madhu
Hi,
this would be a solution:
- create a button, action, run macro --> unzip
- Edit module --> copy your code ad modified in my attachment
- use a .zip as my attachment
it would work (allow access to system to macro).
But your macro code doesn't works. It creates the folder and then it crashs.
Let us know.
S.
Maybe you'd have to replace the lines in the script in the macro:
' Use CopyHere to extract files
objshell.NameSpace(strFolderName).CopyHere
objshell.NameSpace(strFileName).ItemsSet
with
' Use CopyHere to extract files
objshell.NameSpace(strFolderName).CopyHere objshell.NameSpace(strFileName).Item
It seems that now it works.
S.
Maybe, I don't understand very well but on QV exist a editor module of VBS, insert you VBS there and this works