I have developed an Excel VBA procedure which takes my database file, extracts part of it to an intermediate Excel file, calls Word, and does a mail merge to print labels. The intermediate file is the data source for the Word mail merge template.
It all works very well, except that when the VBA procedure closes the mail merge template (without saving it), a dialog box is produced asking the user whether or not to save the intermediate file (the data source). I would like to suppress this dialog box, and close the file without saving, but cannot figure out how to do it.
I'm posting this in the hopes that someone has encountered exactly the same problem and has a solution. I have tried many different approaches without success.
It's really a minor problem, so if you don't know the solution, please don't spend a lot of time trying to figure it out. Thanks!
2007-02-10
15:20:57
·
2 answers
·
asked by
Joliet Jake
3