how to create and execute .vbs file in qlikview

[madhubabum]

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

[simospa]

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.

[simospa]

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.

[uroboros]

Maybe, I don't understand very well but on QV exist a editor module of VBS, insert you VBS there and this works