I have a spreadsheet with a list of global variables.
I would like a code that runs through my project and returns the names of all global variables and values of these global variables, and places them in a spreadheet.
i.e
public variable1 as string
public variable2 as string
public variable3 as string
i would like a new sheet to be created
i would like column a to have the public variables names. i.e a1: variable1, a2: variable2, a3: variable3
i would like column b to have the public variable values: i.e b1: variable1's value, b2: variables2's value, b3: variables3's value
I would like a code that runs through my project and returns the names of all global variables and values of these global variables, and places them in a spreadheet.
i.e
public variable1 as string
public variable2 as string
public variable3 as string
i would like a new sheet to be created
i would like column a to have the public variables names. i.e a1: variable1, a2: variable2, a3: variable3
i would like column b to have the public variable values: i.e b1: variable1's value, b2: variables2's value, b3: variables3's value