Two questions:
1. I have a VBA app, that opens two files, merges the important data into
one, then closes the file I don't need anymore. How can I get it to stop
prompting me to save it, and to not ask me about the large amount of data
left on the clipboard?

2. I know this isn't the right forum, but since I'm asking a question
already, here goes. I wrote a VBA app in word to open an Excel file, load
the data into an array, but it won't unload the excel file from memory. If I
look at the task manager, the file is still open. (in the process of
building this new app, I may have already figured this out, but haven't had
the time to try it.)

Thanks in advance.
John