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