Try this

Application.DisplayAlerts = False


"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