Macro issue - jump from one application to another application and pass the values

Thu, 20 Jan 2011 22:40:22 GMT

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.

Macro issue - jump from one application to another application and pass the values

Oleg_Troyansky — Thu, 20 Jan 2011 23:31:10 GMT

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...

topic Macro issue - jump from one application to another application and pass the values in QlikView

Macro issue - jump from one application to another application and pass the values

Macro issue - jump from one application to another application and pass the values