Application.CutCopyMode = False will clear the clipboard.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 05:37:03 -0800, Risky Dave
wrote:

Hi,

Related to my previous posting:

I am importing data from one workbook to using a macro to automate the
process.

I can move the data ok, but when closing the source workbook from the macro,
I am asked:

a) if I want to save changes
b) "There is a large amount of on the Clipboard. Do you want to be able to
paste this information into another program later?"

I can do a) (Workbooks("nnn").Close SaveChanges=False), but cannot find the
syntax to close the pop-up about the Clipboard. I do not want to make this
data available once the workbook is closed.

Any help would be appreciated.

TIA

Dave