topic Macro use Field Value Selected in QlikView https://community.qlik.com/t5/QlikView/Macro-use-Field-Value-Selected/m-p/1451049#M612824 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P>I would like to<STRONG> launch the following macro and use the field value selected inside this VB macro</STRONG>.</P><P>My purpose is saving an Excel File with the month name selected from the user.</P><P>MonthName is a field!!</P><P></P><P style="padding-left: 30px;"><STRONG>Sub SendReport</STRONG></P><P style="padding-left: 30px;"><STRONG>ActiveDocument.Sheets("SH02").Activate 'edit the sheet </STRONG></P><P style="padding-left: 30px;"><STRONG>'ActiveDocument.reload</STRONG></P><P style="padding-left: 30px;"><STRONG>set objExcel=ActiveDocument.GetSheetObject("CH23") 'edit the sheet object</STRONG></P><P style="padding-left: 30px;"><STRONG>filepath="\\......path..........\"&amp; <SPAN style="color: #ff0000; font-size: 14pt;">MonthName</SPAN> &amp;".xls"&nbsp;&nbsp; 'edit the location of file</STRONG></P><P style="padding-left: 30px;"><STRONG>objExcel.ExportBiff filepath</STRONG></P><P style="padding-left: 30px;"><STRONG>ActiveDocument.GetApplication.Sleep 5000</STRONG></P><P style="padding-left: 30px;"><STRONG>End Sub</STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P>Have you any idea??</P><P></P><P>Thanks in advance!!!<STRONG><BR /></STRONG></P></BODY></HTML> Thu, 07 Sep 2017 14:12:54 GMT 2017-09-07T14:12:54Z Macro use Field Value Selected https://community.qlik.com/t5/QlikView/Macro-use-Field-Value-Selected/m-p/1451049#M612824 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P>I would like to<STRONG> launch the following macro and use the field value selected inside this VB macro</STRONG>.</P><P>My purpose is saving an Excel File with the month name selected from the user.</P><P>MonthName is a field!!</P><P></P><P style="padding-left: 30px;"><STRONG>Sub SendReport</STRONG></P><P style="padding-left: 30px;"><STRONG>ActiveDocument.Sheets("SH02").Activate 'edit the sheet </STRONG></P><P style="padding-left: 30px;"><STRONG>'ActiveDocument.reload</STRONG></P><P style="padding-left: 30px;"><STRONG>set objExcel=ActiveDocument.GetSheetObject("CH23") 'edit the sheet object</STRONG></P><P style="padding-left: 30px;"><STRONG>filepath="\\......path..........\"&amp; <SPAN style="color: #ff0000; font-size: 14pt;">MonthName</SPAN> &amp;".xls"&nbsp;&nbsp; 'edit the location of file</STRONG></P><P style="padding-left: 30px;"><STRONG>objExcel.ExportBiff filepath</STRONG></P><P style="padding-left: 30px;"><STRONG>ActiveDocument.GetApplication.Sleep 5000</STRONG></P><P style="padding-left: 30px;"><STRONG>End Sub</STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P>Have you any idea??</P><P></P><P>Thanks in advance!!!<STRONG><BR /></STRONG></P></BODY></HTML> Thu, 07 Sep 2017 14:12:54 GMT https://community.qlik.com/t5/QlikView/Macro-use-Field-Value-Selected/m-p/1451049#M612824 2017-09-07T14:12:54Z Re: Macro use Field Value Selected https://community.qlik.com/t5/QlikView/Macro-use-Field-Value-Selected/m-p/1451050#M612825 <HTML><HEAD></HEAD><BODY><P>I am not expert in This? But have a look</P><P></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Sub SendReport</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">ActiveDocument.Sheets("SH02").Activate 'edit the sheet</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">'ActiveDocument.reload</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">set objExcel=ActiveDocument.GetSheetObject("CH23") 'edit the sheet object</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">filepath="\\......path..........\"&amp; <STRONG style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit;"><STRONG style="color: #ff0000; font-size: 14pt; font-style: inherit; font-family: inherit; font-weight: inherit;">SubField(</STRONG></STRONG><STRONG style="color: #ff0000; font-size: 14pt; font-style: inherit; font-family: inherit; font-weight: inherit;">Concat(</STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 14pt; font-family: inherit; color: #ff0000;">MonthName, ','), ',', 1)</SPAN> &amp;".xls"&nbsp;&nbsp; 'edit the location of file</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">objExcel.ExportBiff filepath</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">ActiveDocument.GetApplication.Sleep 5000</STRONG></P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">End Sub</STRONG></P></BODY></HTML> Thu, 07 Sep 2017 14:32:35 GMT https://community.qlik.com/t5/QlikView/Macro-use-Field-Value-Selected/m-p/1451050#M612825 Anil_Babu_Samineni 2017-09-07T14:32:35Z