
Clear Clipboard on file.close
I have a
VBA script in Word that opens an Excel file, copies info and pastes
it into the Word document, then closes the Excel file. When I close the
Excel file, I always get a prompt about "..large amount of info on
clipboard, do you want to save it?" How can I bypass this message or clear
the clipboard using VBA?? Right now, I close the file using:
xlbook.close savechanges:=False
Thanks in advance,
Gina Frazier