I have a couple of questions here:
I created an excel doc where the user inputs certain data. The input fields are concatenated as per the requirements of the final deliverable. Then, when the user hits "Submit", the macro that i wrote copies the entire text, opens a word document, pastes the text there and saves the new word document.
Here are my 2 questions:
1. How can I automatically close word after the documents are created? I did appWD.Documents.Close but that only closes the document, but MS word is still open.
2. When the user exits excel, I want that the information they entered not be saved, so that when the next person goes in, they see an empty form which they fill out. How can I clean out that information?
Please help. Thank you.
Bookmarks