Close workbook/clipboard thru macro

Firefly · Mar 28th, 2002, 11:42 AM

I'm writing macros to generate reports from a database. I'm closing a workbook via macro after I've copied a quantity of data into another. I've been able to close the workbook automatically, but I still get the message about data on the clipboard & have to manually click save or delete. Anyway to automate that as well?

Mark O'Brien · Mar 28th, 2002, 11:44 AM

I think this works, use DisplayAlerts like this.





Application.DisplayAlerts = False



'Your code for closing etc

HTH

Juan Pablo González · Mar 28th, 2002, 02:30 PM

Mark, I seem to remember that this isn't affected by DisplayAlerts. You can, however do this before closing:

Application.CutCopyMode = False

or

Range("A1").Copy

Basically, reduce the Clipboard size so Excel won't pop up the message.

Firefly · Mar 28th, 2002, 03:45 PM

Thanks Juan - the Application... line worked just fine!

Mar 28th, 2002, 11:44 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I think this works, use DisplayAlerts like this. Application.DisplayAlerts = False 'Your code for closing etc HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 28th, 2002, 02:30 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Mark, I seem to remember that this isn't affected by DisplayAlerts. You can, however do this before closing: Application.CutCopyMode = False or Range("A1").Copy Basically, reduce the Clipboard size so Excel won't pop up the message. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 11:42 AM	#1
Firefly New Member Join Date: Mar 2002 Posts: 16	I'm writing macros to generate reports from a database. I'm closing a workbook via macro after I've copied a quantity of data into another. I've been able to close the workbook automatically, but I still get the message about data on the clipboard & have to manually click save or delete. Anyway to automate that as well?

Mar 28th, 2002, 03:45 PM	#4
Firefly New Member Join Date: Mar 2002 Posts: 16	Thanks Juan - the Application... line worked just fine!