topic passing values from sub to function in VB in QlikView https://community.qlik.com/t5/QlikView/passing-values-from-sub-to-function-in-VB/m-p/196459#M56530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In my VB macro i declare this variable in my sub Export,<BR /><BR />Path = ActiveDocument.Evaluate("left(DocumentPath(), index(DocumentPath(), '', -1))")<BR />call openFolder(Path) 'I don't know how to pass the Path value to openFolder</P><P>function openFolder(ByVal Path)<BR />Set WshShell = CreateObject("Wscript.Shell")<BR />WSHShell.run Path<BR />end function</P><P>i want to call a function which opens the folder in explorer of Path. is it possible to pass the value of Path to a function? I think it's something like the code above but it doesn't work... Some help would be handy <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 04 Apr 2011 14:31:26 GMT 2011-04-04T14:31:26Z passing values from sub to function in VB https://community.qlik.com/t5/QlikView/passing-values-from-sub-to-function-in-VB/m-p/196459#M56530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In my VB macro i declare this variable in my sub Export,<BR /><BR />Path = ActiveDocument.Evaluate("left(DocumentPath(), index(DocumentPath(), '', -1))")<BR />call openFolder(Path) 'I don't know how to pass the Path value to openFolder</P><P>function openFolder(ByVal Path)<BR />Set WshShell = CreateObject("Wscript.Shell")<BR />WSHShell.run Path<BR />end function</P><P>i want to call a function which opens the folder in explorer of Path. is it possible to pass the value of Path to a function? I think it's something like the code above but it doesn't work... Some help would be handy <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 04 Apr 2011 14:31:26 GMT https://community.qlik.com/t5/QlikView/passing-values-from-sub-to-function-in-VB/m-p/196459#M56530 2011-04-04T14:31:26Z