Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to have a macro to pass the user selection from one application to
another qlikview application.
Macro for jump from one application to other application based on the user selected values to open 2nd application particular sheet
Example :
Application 1 :
User will select Customerno and press the button
Application 2 has to open with Sheet1
Sheet1 has Textobject - we have to pass the value which is selected
from User in application 1 to application 2 .
sub Press
set CustomernoVar = ActiveDocument.Variables("customerno")
CustomerNo = CustomernoVar.GetContent.String
set val=ActiveDocument.Fields("CustomerNo").GetSelectedValues
if (val.count)=0 then
msgbox("Select a Customer Number")
else
showvalue = val.Item(0).Text
set app = ActiveDocument.GetApplication
app.Launch "C:\Program Files\Internet Explorer\IEXPLORE.EXE","qvp://CustomerDetails.qvw&client=Plugin="&(showvalue)
ActiveDocument.Fields("CustomerNo").Select (CustomerNo)
set s = ActiveDocument.ActiveSheet.SheetObjects("SH90").GetSheet
end if
end sub
Advance thanks for your support and help.
I don't think you can do what you are trying to accomplish, using app.launch ...
First of all, if you are on version 9.00 or higher, - why not use the Action and Open the second document with the selections passed through? Much cleaner...
If you can't use an Action, try opening the second document using macro function doc.Open and then propagating user selections etc...