topic Re: VBA script to retrieve row number in QlikView

VBA script to retrieve row number

sibrulotte — Wed, 05 Nov 2014 21:22:55 GMT

Hi,

I'm using a macro that will write "1" to the input field "Confirmation".

Sub Faux_bris

set fld = ActiveDocument.Fields("Confirmation")

fld.SetInputFieldValue XX, "1"

End sub

XX being the row number where to write my "1" to.

I will have the users run the macro when only one possible line is selected in that reduces the Confirmation field to one row.

(does that make sense)

How can I get the row number to replace the XX value?

Re: VBA script to retrieve row number

sibrulotte — Thu, 06 Nov 2014 14:01:02 GMT

40 lurkers, no takers?

Re: VBA script to retrieve row number

sibrulotte — Fri, 07 Nov 2014 14:27:39 GMT

One last try, as I will be in deployment next week...

Re: VBA script to retrieve row number

marcus_sommer — Fri, 07 Nov 2014 15:35:46 GMT

This won't work because selections within the gui to only one possible record didn't affect the macro in this way. You need to delivered the record-number directly - maybe per variable or fieldvalue over a rowno() from script or per functions like fieldindex() and fieldvalue.

- Marcus

Re: VBA script to retrieve row number

sibrulotte — Fri, 07 Nov 2014 15:56:19 GMT

Thank you for the input.

I'll have to look into that. I am fairly novice in Qlikview VBA, so what I'm hearing is

retrieve a rowno() from a cell that will be determined from a fieldindex()...

I need to do my homework before progressing in this. Yhank you again.

Simon