VBA script to retrieve row number

[sibrulotte]

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?

[sibrulotte]

40 lurkers, no takers?

[sibrulotte]

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

[marcus_sommer]

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

[sibrulotte]

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