Need VB code to clear contents of clipboard

[velohead]

Hi All,

I have a macro that opens particular spreadsheets, copies data to a 'master' spreadsheet, then closes the un-needed spreadsheets, 20 in all.

Works well but I get the following message for each spreadsheet being closed...
"there is a large amont of info on the clipboard
click yes to save in clipboard
click no to clear clipboard"

I need to say "No" in each instance of this, ie 20 times each time the macro is run.


Question - what is the command to clear the clipboard WITHOUT saving the file(s), so that I dont need to say "No" in each instance.
Also I prefer NOT to have any 'error handler' such as...on error resume next.

Thx.

 

[Tom Urtis]

Question - what is the command to clear the clipboard WITHOUT saving the file(s), so that I dont need to say "No" in each instance.

Generic syntax example:

Workbooks("WorkbookName.xls").Close False

 

[velohead]

I was using...
Windows("FY12 Budget - AHFS Branch.xls").Activate
ActiveWorkbook.Close

but I am now using...
Windows("FY12 Budget - AHFS Branch.xls").Activate
ActiveWorkbook.Close False


but the clipbooard message still comes up.
It should work with the above I assume ???
Is this correct ?

 

[pcc]

try

Application.CutCopyMode = False

 

[velohead]

Yes,
Application.CutCopyMode = False
works perfectly.

Thanks.