Discussion Board for collaboration on QlikView Scripting.
I'm new to VB script.
In my project, I've got several text objects named Prod1... Prod10
I would like to copy text into a xls worksheet
I would like to make a loop to do the same thing for Prod2, Prod3... Prod10
How can I do ?
Hi Gregory, you can create the straight table (with out dimensions) with all the text objects expressions and export straight table into Excel file.
I could however I would like to manage to do it in this way
Ok then create the loop with Text Object ID's and paste into Excel file.
I try, however I'm not sure about the syntax.
I think about something like?
for i = 1 to 10
Prod & i .Copytexttoclipboard
How could I do it correctly