Save global variables in spreadsheet RRS feed

  • Question

  • Hi I am novice at vba, 

    so unlike other examples here I have no code for this problem.

    I have a load of global variables in Vba. I would like a code that saves the name of all global variables in column a and saves the value of the global variable in column b.

    given that the global variables are strings and integers.

    Monday, August 19, 2013 4:04 PM

All replies

  • Export the module containing the declarations.

    Then read the resulting .bas file back into a worksheet as a text file.

    Then parse the string.


    Monday, August 19, 2013 4:33 PM