4 Replies Latest reply: Mar 4, 2014 3:46 PM by Grégory HERRE RSS

    VB Script : Dynamic object name

    Grégory HERRE

      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