Jump to content

RD4

Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by RD4

  1. Hi,

     

    Is it possible to access property of the object using variable, for example I have the object named "objExample" with properties named:

     

    Property1

    Property2

    Property3

    Property4

    ...

    Property10

     

    I would like to access all of these properties in FOR loop using variable propertyName = " Property " & i in each step, but I don't know how to make it.

     

    The code below it's an simple example of my problem ("???" indicates piece of code which I missing):

     

    Dim i

    Dim propertyName

    Dim objExample

     

    Set objExample = .......

     

    For i = 1 To 10

    propertyName = " Property " & i

    objExample.??? = ......

    ......

    Next

     

    Best regards

×
×
  • Create New...