I often make use of loops in Stata. For instance, if I want to generate a set of similar tables for a number of variables I would type:
It's neat and very simple, put required variable names after the word varlist and introduce them into the loop with use of the `var' keyword.
I want to do analogous loop in VBA. I will use it to automatically generate a number of PDFs. I would like it to look like that:
What I missing is a loop component where I could substitute different text strings for the variable_name. I will appreciate any help on that.