I need to create a button with an action that will pass a value to an excel document. I want the excel document to open with charts that are related to that specific value. the excel sheet is done. It has a drop down that changes the values of the charts. I want the drop down and charts to reflect the value i currently have when i press the button in the qlikview app. Any information would be helpful. I have programming experience, but not much with qlikview or vb script. If i can get a high level explanation how this can be accomplished (A to Z)I will do all the rest of the leg work.
So, there is no way to capture a variable's value in qlikview and pass it to an excel sheet? And, open the excel sheet based on the value that was passed. For clarification I'm not trying to export to excel. The excel file has all the data I just need a user id from qlikview to show the corresponding data in the excel sheet. this can't be done with vbscript or powershell? how about windows directory?
