New user here... Forgive my ignorance but I've read http://www.vbaexpress.com/forum/show...form-with-data a few times and haven't been able to figure out how to apply it to my macro.
My situation is that I have a macro with a lot of fields (~40) that are input by the user, such as names, addresses, phone numbers and others. From that data, using a command button and a bunch of code (a few thousand lines,) the macro generates word documents based on the information input into the form by the user. What I want to do is for the macro to save the data (somewhere/somehow) that has been input so that, when the form closes, if a user finds out that they need to change 1 field, they don't have to enter everything again; they can re-load the macro, with the data that was input previously and just change the one field and re-generate the documents.
Can anyone shed some light on how to save all the data when the macro closes so it can be accessed next time it is run?