Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

passing values from sub to function in VB

Hi,

In my VB macro i declare this variable in my sub Export,

Path = ActiveDocument.Evaluate("left(DocumentPath(), index(DocumentPath(), '', -1))")
call openFolder(Path) 'I don't know how to pass the Path value to openFolder

function openFolder(ByVal Path)
Set WshShell = CreateObject("Wscript.Shell")
WSHShell.run Path
end function

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 🙂

0 Replies