How on vba to create and initialize such an object?

How to create a similar object in vba
{ "field1": 091,
"field2": 901,
"field3": 909
}
April 3rd 20 at 17:15
2 answers
April 3rd 20 at 17:17
Solution
Not that hard to Google, okay

Here's the tool (github) to work with the "object" (called JSON).

Here here also solved the problem
a built-in tool present? - corbin_Wym commented on April 3rd 20 at 17:20
@corbin_Wym, unfortunately, have not met personally. My guess is no, because almost all tutorials in the network lead to the above-described tool. But in any case, even if you want to write your own parser, you will come up plus or minus to this decision - deshawn.Cummerata commented on April 3rd 20 at 17:23
@DeeDee.Cummerata, and maybe even tell me how to repeat the letter " n " times?
In JS you could just write "f" * 4 and turned "ffff"
how it is possible in vba to do this? - corbin_Wym commented on April 3rd 20 at 17:26
@corbin_Wym, well, in the VBA can napisati a function that takes 2 arguments. The 1st is the original string, the 2nd is the number of repetitions.
As a result, return the result.
How will the function under the hood: takes 2 arguments. Declares an empty string result. Then loop from 0 to the 2nd argument (for example n) concatenates to the initially empty string-result 1st argument (the source string). And gives the resulting - deshawn.Cummerata commented on April 3rd 20 at 17:29
April 3rd 20 at 17:19
Solution
In VBA, you can use dictionaries. Perhaps this is what you need in your case.
Link in the description

Find more questions by tags Visual BasicExcel