Hello all,

I would like to be able to use code to modify code, specifically a constant held in my macro. e.g; if I enter a name as a parameter "Ms Scarlet" i would like the current value held in the constant to be updated for future use:

From:
Public Const strSalesRepName As String = "Colonel Mustard"
To:
Public Const strSalesRepName As String = "Ms Scarlet"
The change must be saved, so tha the next time the add-in is run, the new value is still relevant.

Again, any assistance s appreciated.