I have a function which copies a very large amount of
records and pastes them to a new table. I do not want to
save this data to the clipboard when I close the original
table (in fact, this causes the program to crash).
Normally, the table prompts the user if they want to save
the clipboard data or not, but I am not sure how to
select "No" from that dialog box using VBA.

Therefore, is there any way to either
1) Clear the clipboard data before closing the table or
2) Somehow select "No" from the dialog box that pops up?

Thanks!