topic Reference values from a table in VBA code in QlikView https://community.qlik.com/t5/QlikView/Reference-values-from-a-table-in-VBA-code/m-p/201195#M59410 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>In my VBA code, I am trying to reference values in a specifc table. Can this be done? I need something like:</P><P>For each value of var1 in table T01</P><P>If var1 = 'New York' Then VBA_NY_Count = var2</P><P>Loop</P><P>AND THEN</P><P>if the row number in table T02 &lt; VB_NY_Count then export row to Excel (or select and copy/paste to Excel)</P><P>Any suggestions or a starting point would be greatly appreciated!</P></BODY></HTML> Wed, 06 Apr 2011 18:51:50 GMT 2011-04-06T18:51:50Z Reference values from a table in VBA code https://community.qlik.com/t5/QlikView/Reference-values-from-a-table-in-VBA-code/m-p/201195#M59410 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>In my VBA code, I am trying to reference values in a specifc table. Can this be done? I need something like:</P><P>For each value of var1 in table T01</P><P>If var1 = 'New York' Then VBA_NY_Count = var2</P><P>Loop</P><P>AND THEN</P><P>if the row number in table T02 &lt; VB_NY_Count then export row to Excel (or select and copy/paste to Excel)</P><P>Any suggestions or a starting point would be greatly appreciated!</P></BODY></HTML> Wed, 06 Apr 2011 18:51:50 GMT https://community.qlik.com/t5/QlikView/Reference-values-from-a-table-in-VBA-code/m-p/201195#M59410 2011-04-06T18:51:50Z