Save Form With Data
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?
Reply With Quote