topic Re: VB Script : Dynamic object name in QlikView

VB Script : Dynamic object name

Tue, 04 Mar 2014 14:20:36 GMT

Hi Community,

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

Prod1.Copytexttoclipboard

XLDoc.Sheets("Sheet1").range("A1").select

XLDoc.Sheets("Sheet1").paste

I would like to make a loop to do the same thing for Prod2, Prod3... Prod10

How can I do ?

Greg

Tue, 04 Mar 2014 14:23:40 GMT

Hi Gregory, you can create the straight table (with out dimensions) with all the text objects expressions and export straight table into Excel file.

Tue, 04 Mar 2014 15:23:13 GMT

I could however I would like to manage to do it in this way

Tue, 04 Mar 2014 19:40:38 GMT

Ok then create the loop with Text Object ID's and paste into Excel file.

Tue, 04 Mar 2014 20:46:42 GMT

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