I'm running an Excel Macro fro inside of an access module. Part of the Excel macro does a copy paste.
How can I stop the message box "You have a lot of data copied to the clipboard"..asking "do you want to save the data on the clipboard?" ?

This keeps me from being able to save/close the spreadsheet in Access.

I assume I'd have to add something to disable the warning in Excel, but docmd. setwarning=false, does not work as it does in Access.