topic Macro Help in QlikView https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366152#M702233 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need help with writing a macro. I have a popup box that asks if the user wants to export to Excel. If the answer is yes, I want the document to copy ObjectID "CH112" into Excel. So far, all I have is the message box, and I don't know how to tell it to Open Excel and export the object. Please help.</P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="color: #0000ff;">Sub ShowPopup</SPAN><BR /><BR /><BR /><BR /><SPAN style="color: #0000ff;">x=MsgBox("Would you like to export search results to Excel?",4,"Export Excel")</SPAN><BR /><BR /><BR /><BR /><SPAN style="color: #0000ff;">End Sub </SPAN></P><P></P><P></P><P></P><P></P><P>Thanks!</P></BODY></HTML> Tue, 24 Jul 2012 19:38:21 GMT 2012-07-24T19:38:21Z Macro Help https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366152#M702233 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need help with writing a macro. I have a popup box that asks if the user wants to export to Excel. If the answer is yes, I want the document to copy ObjectID "CH112" into Excel. So far, all I have is the message box, and I don't know how to tell it to Open Excel and export the object. Please help.</P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="color: #0000ff;">Sub ShowPopup</SPAN><BR /><BR /><BR /><BR /><SPAN style="color: #0000ff;">x=MsgBox("Would you like to export search results to Excel?",4,"Export Excel")</SPAN><BR /><BR /><BR /><BR /><SPAN style="color: #0000ff;">End Sub </SPAN></P><P></P><P></P><P></P><P></P><P>Thanks!</P></BODY></HTML> Tue, 24 Jul 2012 19:38:21 GMT https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366152#M702233 2012-07-24T19:38:21Z Re: Macro Help https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366153#M702234 <HTML><HEAD></HEAD><BODY><P>check this:</P></BODY></HTML> Tue, 24 Jul 2012 20:36:30 GMT https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366153#M702234 2012-07-24T20:36:30Z Re: Macro Help https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366154#M702235 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Please look at these threads and hope that helps.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Advanced Export to Excel:</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/8253#8253" title="http://community.qlik.com/message/8253#8253">http://community.qlik.com/message/8253#8253</A></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Loop Object ID:</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/15557#15557" title="http://community.qlik.com/message/15557#15557">http://community.qlik.com/message/15557#15557</A></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can use combination of both the ideas to suffice your need.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P><A href="http://QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Wed, 25 Jul 2012 06:25:20 GMT https://community.qlik.com/t5/QlikView/Macro-Help/m-p/366154#M702235 IAMDV 2012-07-25T06:25:20Z